Hello,
If someone could please help, that would be great!
I have 3 actions buttons. The first button (En Route Date Time) creates a new row in another sheet, and enters in some basic info, including the date and time based on NOW()
The 2nd button stamps the On Site Date Time on that row
The 3rd button stamps the completed or Cleared Date Time on that row
What I need to accomplish is prior to a new row being created, only the En Route Date Time button is present. Once the action is completed (a date and time is entered in the En Route Date Time column), I need that button do disappear, and only display the On Site Date Time Button. Once that action is completed, only display the Cleared Date Time button. Once that action is completed, start over with only the En Route Date Time button showing.
Utilizing the "Only if this condition is true" option for each action, I'm trying this approach. I can get everything to work except the first En Route Date Time button. It's always present, no matter what.
En Route Date Time action condition currently:
ISBLANK(SELECT(Time[Time Record #], AND([Entered By Email] = USEREMAIL(), ISBLANK([En Route Date Time]), [Jobs Record #] = [_THISROW])))
On Site Date Time action condition currently:
ISNOTBLANK(SELECT(Time[Time Record #], AND([Entered By Email] = USEREMAIL(), ISBLANK([On Site Date Time]), [Jobs Record #] = [_THISROW])))
Cleared Date Time action condition currently:
ISNOTBLANK(SELECT(Time[Time Record #], AND([Entered By Email] = USEREMAIL(), ISBLANK([Cleared Date Time]), [Jobs Record #] = [_THISROW])))
Thanks in advance for any assistance!
Solved! Go to Solution.
Nevermind, I got it working. I assumed when you put [Related Times] it was a placeholder for the correct column. I have now realized that it was a virtual column added when I made it a ref.
This worked perfectly!
OR(
ISBLANK([Related Times]),
ISNOTBLANK(INDEX(
SELECT( [Related Times][Cleared Date Time],
[Entered By Email]=USEREMAIL()
),
COUNT(SELECT([Related Times][Cleared Date Time],
[Entered By Email]=USEREMAIL()
)
)
)
)
)
User | Count |
---|---|
18 | |
11 | |
7 | |
4 | |
3 |