Setting a date based upon another date
Hi everyone, long time Smartsheet user first time poster here.
I am seeking help in setting a date column based upon another date column.
Put simply, I have a "date received" column and a "created" column, where the created column populates automatically based upon the time a submission was made using a form. The "date received" column I have been manually setting, as any work received after close of business (5:00pm) we consider as being received the following day.
So I'm seeking help in writing a formula that essentially says "If (created) is greater than 5:00pm and less than 11:59pm, set (date received) to tomorrow. If (created) is earlier than 5:00pm, set (date received) to today".
Help Article Resources
Check out the Formula Handbook template!