-
Linking to other cells
Hey, So we have 2 sheets. New Projects sheet and Tasks sheet. The New Projects one have 2 column. ID and name of the project, whenever we get a new project we insert the name and ID manually. I want the Tasks sheet to have those column as well (ID and name) and I want it to be dynamic. Meaning we add on Projects sheet, it…
-
Smartsheet collaboration with Microsoft Teams
Hi, I want to know the accessibility rights of the different types of users (licensed, non-licensed, collaborator...) Example: I want 2 users to be admins so they can add users and create sheets. And I need 20 users to be able to access the sheets, input, and edit information. Also, I need 100 users to be able to view the…
-
Filter "is one of" drop down lists
Is there a way to clean up the drop down list on "is one of" filters? They still contain items that have been totally deleted from the column being filtered. This is very confusing to users. Thanks
-
URL for Welcome screen
I tried to upload a web page (html) to my OneDrive and then copied the link to "URL for Welcome screen". However, nothing show in the Welcome screen. How can I make my web page as smartsheet welcome page?
-
Does anyone have a grant/program management template to share?
I need a template that will help my team track relatiosnhip management, and grantee relatiosnips- especiallly regarding grant milestone progress.
-
Sending a row automatically after changing a cell
Hi all, Is there a way to program a trigger to send a row automatically? thanks!
-
Sort columns by color
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
-
Keep users from back-filling completed dates
is there a way to set a date column so that only the current date can be entered? Right now we have START, DUE AND COMPLETED DATE columns. The problem is that people are back-filling the completed date, for example putting in a 3/1 completed date on 4/1. We would like to get people to fill in the completed date on the…
-
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
