Formula in Drop Down List

Adum

I need to have an excel Drop Down list that includes the "NOW" formula (date and time now) and Pending

Debbie Sawyer

Can you explain the scenario a little more?

You cannot have formula in dropdown lists, but you can use IF functions in helper columns to read the value from a drop down list and perform a function based on its value.

Maybe this could help you?

If you explain a little more, I can suggest the functions for the helper column?

Kind regards

Debbie

Adum

Hi Debbie,

I need my printing dept to tell me they are starting a job NOW. They are not quite computer literate enough to insert formula.

In an ideal world I would also like to learn if there is an EASY SHORTCUT that anyone could type in a field that would insert a future date.

Debbie Sawyer

Why don't you get them to check a box, then you can use the record date automation to update the sheet with the date when the box was checked. However this won't give you the time.

The workflow below says if the Printed box is ticked then set todays date in the When Printed column.

You can see from the results that the time doesn't get captured though.

If you need the time to be recorded, we can capture it in a Text format using the following add-in that SBP developed before the date recorder was available. However the code which captures the time is in a text format, so would just be for reference.

See here:

https://www.smarterbusinessprocesses.com/smartercontrols4smartsheet-cell-level-timestamp-manage/

Does this help at all?

Kind regards

Debbie

Andrée Starå

Hi @Adum

To add to Debbie's excellent advice/answer.

You could use the dropdown list and use that together with Debbie's suggestion using the Record a date feature.

If you need the time as well, you can use a method I developed natively in Smartsheet.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Also, the shortcut to get today's date in a date cell is, T

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Adum

Thank you Debbie and Andree,

I'll give it a shot.

Best,

Andre

Adum

Thank you Debbie.

You have been most helpful.

Best,

Andre