-
Risk Status on my Smartsheet using formulas
I am using Blue, Green, Yellow and Red for my project status - I have a formula around it that will change the color accordingly. What I want to do is if the color ever turns Yellow or Red log it as a risk in another column. I can get it to work but if it is ever a risk I want it to remain a risk even if the task turns…
-
Dashboard
How can I create an A0 landscape dashboard canvas
-
Developing a Matrix Questionnaire
Hello, I am hoping someone can help me design this type of Survey Form to send out to my work employees. I would like to ask them to pick an answer (that I give them), by selecting the radio button. It seems easy enough however, I do not see this. I have attached a screenshot. If you know how to do this, I would really…
-
Adding back in deleted rows
Hi, How would you recommend I add back in the action indicator row if it was previously removed by another user TIA
-
Sheet Data Reports
Hello SmartSheet community! We've been using Smartsheet for a while now throughout our company and so far have several sheets. Some have important deadlines/dates while some just have to-do lists with several tasks that are flagged as important. I'm having difficulty figuring out how to compile all of the upcoming dates,…
-
Vlookup
I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response. I want to use this data to link to another sheet that I am using to track open invoices via Vlookup. When I populate the sheet I have been inserting rows on top so…
-
Conditional Formatting Bug
I set up my conditional formatting to colour code my "type" column as a visual reminder on my action. It worked for many weeks but now when I insert a row and use the "type" column to select a type from the drop down menu, it formats that cell as white background and white writing (showing nothing selected). My conditional…
-
Contacts and Contact Groups
Can you share contacts or contact groups with other smartsheet users? Similar to how you share a filter or another way?
-
sharing permision
Hello, I work for a construction company and we use smartsheet to manage our project and we would like to share a folder without sharing the entire work space thank you :)
-
Regularly emailed project sheet - how do I update the email body text??
I am a relatively newish user of Smartsheet and have used it about 3 months. A co-worker helped me to set up a regular email to be sent out to my team with my project list attached. The email body of that email that goes out needs to be edited. I can't figure out now how to go back and make any edits to that. Any ideas???