-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
-
Editing Alerts & Notifications - how do I get rules to fire on existing entries
Hi All, Basically I want to know how I can re-fire alerts and notifications that failed due to errors and have been subsequently edited. Example described below We are testing a new smartsheet using alerts and notifications and a multi step approval process based on thresholds. We submitted multiple Smartsheet forms today…
-
If(And Future date formula not working..please help
I cant see it for looking, this formula should work (attached0
-
How to manage smartsheet?
Can somebody help me how to manage the Smartsheet because this is my fist time using it, so now it's like i cant do anything on it actually i don't know anything here......can somebody help me please.
-
"Sorry, notifications are temporarily unavailable but should be back soon."
For the past few days I've been receiving the following error message when trying to load the new notifications tray: "Sorry, notifications are temporarily unavailable but should be back soon." Any idea what's up?
-
Smart Sheet I have a question......"Save As New"
Hi Team, If "Save as New... gives you "Date & Formatting Options" to tick and untick what you want. Sheet data & Formatting, Cell linking, Sheet filters and forms, attachments etc. etc. Why cant there be an option to have "formulas" move with the row to another sheet. If you "Save as New" five times, then you have five…
-
Max no. of submissions for free account
Hello, is there a maximum number of submissions you can collect from a form if you have a free account or is there a max no. of times you can send out one particular form?? Thanks!
-
Automated update request
Hi, I have a task that need to monitor status of monthly building reports to clients. The process is like as following: 1. Form department will generate building reports (each person in Form department has their own portfolio). 2. they will fill in the form on SmartSheet to input when they create the building reports and…
-
Predicting a bad situation
I have projects with 3 milestones, call them A, B, C C is dependent on B which is dependent on A. C is a critical completion date. If either A or B is late, C is automatically late and that is very bad. If A or B is late by X number of days, C automatically is now going to be late by that same number of days. I'm looking…
-
Two dimensional cards
Hi. When looking at the card view, it'd be useful to be able to see multiple dimensionality. For example, being able to see which cards each user has in which status. (see attached) Is there a way to set up that sort of view? (I have person and status both available in separate pulldowns) Matt
