-
How can I set up a Notification if my Primary Column is not a contact list, but the Requestors email?
Hi, Is there a way that I can set up a Notification Automation that goes to the email/requestor is their email is the Primary Column? Currently I have the Primary column as "Created By", and the requestors input their email address. But, if I try to set up a Notification automation using the Template or even from Scratch.…
-
Need help with a formula to determine if all responses have been received for each group in the Smartsheet
Hi! Thanks in advance for taking a look! I have a Smartsheet that has a line for each person being reviewed as well as their "client number". I created a helper row to let me know when each person has completed their actions, but I'm having a hard time finding a way to indicate when everyone for that client number has…
-
HOW TO USE IF BLANK WITH THIS FORMULA
I am using this formula to return the month and year from a reference date, but cannot figure out how to use IFBLANK with it in order to return a blank cell if the reference date cell is empty. This is the formula I am using and trying to add IFBLANK to. =IF(MONTH([WALL DESIGN FINISH (ACTUAL)]@row) = 1, "01-",…
-
Why the dropdown menu is not searching for the first characther anymore?
Since a few days ago, the smartsheet started working differently. I used to write in a cell with dropdown menu the number "5" for example, and would show me the option "5 - built" straight away as first option. Now if I do the same, the first option that appears is "0.5 - waiting", this is really annoying because after…
-
Sheets referenced in a report
I have created a report to rollup information from several sheets. I am trying to edit the sheets included in the rollup, but when I click on the "tab" for sheets, I see two of the 13 liste.d. The scroll option is not working to show all the sheets How can I see all 13 sheets, delete the ones I do not want to include and…
-
Recording multiple instances of a project on/off track
Hi there! I am currently using a project info sheet and a project plan that are tied together using a metadata sheet. We now have a need to track each instance a project is off track for each project (project status is changed from On Track to Behind Schedule or Over Budget). I also need to calculate the number of days it…
-
Row level Automation tracking
There should be a column option (like created by) that displays what automation last was applied to that row. You could see a history of what automations ran by using the cell history. This would require the use of automation ID's since the name/title of the automation could change. Automation ID's are assigned today, but…
-
Display Attachment Names in a Column
Hi everyone, Is there a way to display the attachment name(s) in a column?
-
Custom Branding on Update Request Automations
Custom branding works on Alert type automations, but it would be great if that same branding was applied to Update Request automations as well.
-
Has anyone else had issues with the new Contact Support chat box?
I clicked "Contact Support" and a blank chat box appeared. I could not see any text I entered. When I clicked "Download transcript", I could see the text and apparently someone had responded but I could not see it. Furthermore, after clicking to download the transcript, the chat box disappeared and I had to close to enter…