-
Form input to a categorized view
I'm using the Project Mgmt Office template. I'd like my form data to populate a sheet that looks like the above screenshot. Can a new form submission populate child rows under "New" category? And, once the status of project changes from "New" to "SCOPING", can the sheet update automatically and the child row appear under…
-
A workflow has become invalid
Hello, I have had this problem for over a month! I receive the notification "A workflow has become invalid" and I go to the workflow, delete it and do it again. It works for a while and then it happens again. I already set the "Automation Permissions" to Unrestricted and it still doesn't work! I followed up with the person…
-
Highlighting Gantt Chart Date Columns
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspension period. Is there anyway to do that? If not, can I submit that as a feature…
-
Display a message / Instructions if cell is empty
If I have a cell that needs input, like a persons name, but if that info is not filled out based on another column how would I make it generate or display a message? I have column - Plates Made By, I want a message to display if this info is missing. Based on column(s),Column - # of Plate Made, Column - Shift, Column -…
-
Change "From" when sending Update Request
When sending an Update Request, is it possible to change the From person? My sheet was created by someone else but I want to set up a reminder update request that would appear to come from me instead of the owner. I'm currently an Admin on the sheet. TIA! Colin
-
Possible to create multiple linked templates?
Hi All, Hoping there's a few Smartsheet super users out there that can help! I've created a pretty flash client specific dashboard which pulls in from one master project template, which is is also linked to about another 10 seperate report sheets. Without cloning and linking it all up again, I was wondering if there was a…
-
Can Approval Requests send attachments
So I have a process in place where when an attachment is added it triggers an approval request. When the request goes out I want that attachment to be sent via email as a part of this request, is this something that is possible? Currently I am only seeing the ability for the person who approves to add an attachment and not…
-
Automate discussion emails?
Hi, I was curious to know if there was a way to automate the discussions so that everyone within a contact column (or multiple contact columns) could be notified whenever there is a new discussion added, similar to when someone @mentions a name?
-
Locking a Formula in a Column
I created a formula in a column that I do not want people to be able to change, but to still function as people add new information in the rows. By locking the column, will the formula still work (the cell will still populat/update) when the reference cell in the row is updated?
-
Notifications with Google Hangouts?
I have Google Hangouts bot activated in Smartsheet and the two bots connected. Despite that, I can't manage to create an Automated Notification that sends to Google Hangouts. Anyone know how to do that? I would expect an option to appear here (see screenshot) like the Slack option does but I can't make it pop up. Help?