Im also wondering if i can change a dropdown with symbols using a work flow?
You would need a helper column to change to current date then in the cell you want the actual date to be you would need to use the formula of =[helper column date]@row+7
For the symbol you would need to do something similar as symbol automation is not currently an option that I am aware of but you can have a helper column change to specific criteria and then set up a formula in your symbol column to reference that cell with an if formula to get the symbol you would like to appear when the cell is changed to the specified criteria
@Brandon Morales You can use the record a date automation for the date and change a cell automation for the symbols.
thanks, this records the current date. is there a way to record the current date plus 7 days?
Also when i use the change cell automation, my symbol dropdown doesnt appear as an option to change cell:
Ok great, I was thinking something along those lines would need to happen- thank you Holly!
Is is possible to create an app in workapps and have the users enter/edit information through reports without having them to log into smartsheets? I need users to provide input to specific action items but I don't want to have to set up a username and password to access SS. thanks in advance.
Hi all, I have a project overview sheet, which hold information about various subspecialty projects, and I would like to share this sheet with respective subspecialty team members based on their area. I have a column in the source sheet with dropdown (containing various subspecialties/areas), and I am wandering if there is…
Dear All: Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.