Hello! I'm trying to have the "Date Resolved" column auto populate when the "Send Response to Requestor" is checked. This is the formula I'm using: =IF([SEND RESPONSE TO REQUSTOR] = "1", TODAY())
Here's a screen shot of my sheet:
The issue with that formula is that it will update every day when you open the sheet anew, as TODAY will be a different date each day. At this time we don't have a timestamp function, please submit an Enhancement Request when you have a minute!
You could input a Date Modified system column in the sheet, although this will update the date if anything else changes in the row. Depending on what plan you're on, you could check the Activity Log to see when that column was changed, or on any plan you can right-click on the cell and check the Cell History.
If none of these alternatives will work for you, you may want to look into using Zapier to connect Smartsheet with another application that can record timestamps for you.
Thank you for this information, but I don't know how to use Zapier. I just tried and I don't understand it and I don't have the time to experiment. I need to be able to run reports and provide metrics measuring response time and I need to make it easier for the team (as this is functionality that will be across 22 sheets/forms) to respond.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
So, I'm looking to essentially trigger a value if a certain box is checked (indicating amount due was paid) to then transfer that due amount into the paid amount column. I'm struggling due to my limited knowledge, but the formula I've been working on is =IF(checked[Lift Paid@row6], =[Lift Amount Due]@row6). Is it an issue…
Hoping for either formula help or suggestions for how to restructure the data so that I can make this happen! Please let me know if I can clarify anything and thanks in advance to anyone willing to take a stab at this. Main sheet: list of events; one row per event, with the following columns: Event name (text) Attendee…
I have the following data where I am trying to parse the (ISPHUBS-6AAA) from the string below. Assets 1 = ORRR39-ORMOOO-BEACH (ISPHUBS-6AAA) I use the RIGHT formula ... =RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row)) But I get the following string returned Result = -BEACH (ISPHUBS-6AAA) How do I get just the…
©2024. All Rights Reserved Smartsheet Inc.