-
Getting approval notifications to email working
Hello folks, I have created a travel approval workflow whereby once a request for approval is submitted from a form populating a new row in a sheet, it should notify the approver via email. I can't seem to get it to work. The notification comes within the notifications center in the app (desktop and mobile), but the email…
-
Adding a freeform text field to an Update Request
I am using an Update Request that is emailed out to a user. When the user clicks the button VIEW REQUEST another dialogue box appears with the fields (columns) I chose to show. One of the fields, I want the user to be able to enter data to a free from text field. The column where I want the input data stored is set as a…
-
Restricting View after Sharing
Hello, I am wondering if it's possible to toggle whether or not people can view a workspace I've created. In this particular instance, there is a large set of different sheets that are updated monthly for SLAs and are then sent to a corporate team for review. We want them to be able to see the finished product and all the…
-
Updating projects
Can anyone advise on this please? I am looking at a better way to set a smartsheet page up for weekly updates. Presently we add a new column for each week, but clearly as the project evolves more columns will be added. Has anyone got any suggestions that I could use please? I know we could add to comments but this could'nt…
-
Help with Multiple IF/THEN in one formula
Hello I am trying to create a report to show actual complete date success vs. target complete date success at the project level (my row hierarchy is Category>Project>Task). So I figured I needed to create a column called On Time? that compares cell Actual Complete Date vs. cell Target Complete date. But I only want to do…
-
Alert to User Who Made Cell Change
Hi - I cannot figure out how to word my need so that I can search for it in the community posts. I am looking for either an alert or reminder, I think, for this situation: A user, *not always the same user*, adds a job number to the 'job number' column but left the 'approved hours' column blank. As Smartsheet is constantly…
-
Late task notification
Hi. I'm trying to send notifications to users who have overdue tasks, i.e. tasks that are not complete and the due date is now in the past. I'm seriously shocked to find that this functionality doesn't even exist as a pre-made notification already...? Am I the only person who wants to notify staff when they're late? The…
-
new features?
Upon opening smartsheet today it did an update and said it was adding new features... Does anyone know what they are?
-
Entering a Day of the Week Should Input the NEXT Occurrence of that Day
If I am working on my sheet on a Wednesday, and in a date column I enter "Monday", it automatically enters the date for the preceding Monday. It would be much more useful if it entered the date for the following Monday.
-
Adding holidays to smartsheet gantt view
Hi, I've got a GANTT chart with dependencies, so if a task is delayed / time is added it will have a knock on effect to all other tasks along the critical path. One thing I'd like to add is a 'holiday block' where during the month of February nothing is actioned. If a task falls over February, I'd like it to be split. eg:…
