I'm looking to set a rule for when my 'Finish' date column pass my 'Completion' date column. When I try to set the rule it only allows me set when passes a fixed date rather that a date set in a certain column?
any help welcome.
thanks
G
Hi Gareth,
What you're proposing is absolutely possible. Are you receiving an error?
The formula you're looking for will be something like:
=IF(Finish1 > Completion1, "True", "False")
You'll need to make sure you're comparing the same column types, so both Finish and Completion will have to be Date formatted columns.
Kind regards,Chris McKay
This discussion was created from comments split from: Workaround for Grouped Reports with multi-select dropdowns.
Good afternoon, Somehow I deleted an entire smart sheet of information. I went into the activity log and I was able to take a snapshot, but now Smartsheet is not letting me import the new information in the smart sheet
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
