-
Conditional Formatting - Cell
Hello, How can I get conditional formatting to apply to a cell that matches a value in a column? It only lets me highlight an entire row or column, not just the individual matching cell.
-
External URL
How can I make a link to an external url so people can click on the link and it takes them to open up a webpage?
-
Sign up form conditions
I am creating a sign up form with dates, but how can I set up conditions where if one date is taken then it alerts someone to select another date?
-
Conditional Formatting one row at a time
Hello, when I set up conditional formatting on a sheet it applies to the entire sheet. I would like to set a different criteria for each row and when the conditions are met, I would like that row to turn red. How can this be achieved?
-
Notifications including comments
Hello, I am needing the notification that gets sent from a SmartSheet to show the body of the comments. Currently it only shows the comment symbol as below. The other formatting change i would like is to run the row vertical rather than horizontal. Thanks!
-
Rule (Formula) to Check a box if the create date is past 90 days
Thanks for checking this out as my formula game is pretty weak. I am looking to have a formula that will check a box if the create date is 90 days in the past provided another box was checked.Real world I want to call out all statements of work that are older than 90 and we have not received a purchase order (PO received…
-
If a checkbox
Hello again. I need some help please with automation/formula on a project management sheet we use. (Action 1) I have a checkbox column called "SNAGS" When this is checked, I need a date column called "SNAG ADDED" to auto populate the date in which the checkbox was ticked by the project manager. (Action 2) Like wise, I have…
-
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
-
Equipment Check-out...
Has anyone implemented a sheet for use as an equipment check-out form? That is a web form that is filled out by the user which allows them to select from a database of available equipment and indicate the length of use in days? I think I could do that with a column dropdown list populated with the items that are available.…