Sign in to join the conversation:
Is it possible to write a formula using the date that a cell was last amended?
Unfortunately the only thing that can be used this way is either the Created date or the Modified date type columns.
The Modified date would work if that was the only cell in the row being updated, but if anything else updates (to include a formula result) it will reset the Modified date.
Other than that, manual entry of the date would be required.
That's a shame. Thanks anyway.
Is it anything we might expect to see in the future?
I certainly hope so. I have seen it requested quite a bit here in the community. You may be able to find a 3rd party app to pull the time/date stamp from the cell history, but that's just a guess at this point.
Thanks Paul!
Sure thing. Sorry I couldn't be of more help. Hopefully you get it figured out.
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
