Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
I would like to set a date "Completed" based on a status of " Completed"
I have a status column and one of my choices you can pick is "Completed" . When you pick "Completed" I want to set the date in the next column to the date that "Complete" was selected and I don't want the date to change once it is set unless the status changes from "Complete"
Best Answers
-
Hi @Sean Corcoran ,
Unfortunately there isn't a good way to do this other than to manually enter a date after selecting Complete. Smartsheet has some solutions in testing, though. Hope it comes out soon because it will be very helpful.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Please have a look at my post below with a method I developed.
More info:
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Word on the street is that a Record a date workflow action will be coming soon to Smartsheet. It was announced at Engage 2020. Hold tight cause that feature IS coming.
Answers
-
Hi @Sean Corcoran ,
Unfortunately there isn't a good way to do this other than to manually enter a date after selecting Complete. Smartsheet has some solutions in testing, though. Hope it comes out soon because it will be very helpful.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Please have a look at my post below with a method I developed.
More info:
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Word on the street is that a Record a date workflow action will be coming soon to Smartsheet. It was announced at Engage 2020. Hold tight cause that feature IS coming.
-
Thanks, I am new to Smartsheet about 60 days and before I post these is there any word on the street about the following or am I missing something:
Add a note on cell like you can in excel
Limit choice in drop-down list based another drop-down list
Adding people once to task comment so they always get notified so you don't need to @them each time?
-
- No - no ability to add a note on a cell. But you can add comments to a row as you know. One option we've done is add a note column to add notes about specific information.
- I don't think so. But, do you have a specific use case in mind? I might have some workarounds that might work for you if your user is using forms.
- The following article about conversations indicates that if an @mentioned user responds to the comment then they will get future comments. But not unless they respond.
-
You're more than welcome!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
1 - A little clarity of what I am trying to do. Some of our task are a paragraph long explaining what needs to be done. It would be great if I could have a short description of the task so the row is not really tall showing all the test making the sheet longer but only give the detail of the task if you click on the cell like in Excel.
2 - In my sheet I have two columns one column is "department" the other is "work stream". Based on what "department" you pick the choices for "workstream" are not the same. It would just make it easier for a user to have a shorter list to look at related to their department and less chance of someone picking the wrong "work stream"
Again thank you for the help
-
1 - A little clarity of what I am trying to do. Some of our task are a paragraph long explaining what needs to be done. It would be great if I could have a short description of the task so the row is not really tall showing all the test making the sheet longer but only give the detail of the task if you click on the cell like in Excel.
2 - In my sheet I have two columns one column is "department" the other is "work stream". Based on what "department" you pick the choices for "workstream" are not the same. It would just make it easier for a user to have a shorter list to look at related to their department and less chance of someone picking the wrong "work stream"
Again thank you for the help
-
What about creating a separate notes sheet with a column for notes and the actual notes and then cell link the note's title so that when a user double clicks on the cell it will load the new sheet with the note?
See the following video for an example.
-
You're more than welcome!
I saw that Mike answered already!
Let me know if I can help with anything else!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summar…
