-
How to: Force Dashboard to be default screen when starting Smartsheet?
Is it possible to force the Dashboard to be on top each time you open Smartsheet? I searched but found no informationabout this, and any options are not obvious to me. I think it would be quite useful to always open to the To-Do list.
-
Create an update request for a single row, and send to an email listed in that row ?
I have a contact list with 500 rows, one for each employee, that requires constant updating as staffing changes. Is it possible to create an update request for a single row, and have that request go out only to an email address listed in the row, permitting each user to view and update only their own information in one row…
-
How can I automatically capture date of entry on form
Hello - I've setup a webform for users to enter information about potential participants in a program. I want the form to automatically capture the date when the form is completed. I had initially set it up where I established a date field on the form but hid it from users. I thought by selecting 'Today' from the drop-down…
-
Nesting Formulas excluding future dates
Hallo Everyone I have a Nested Formula that looks like this. =IF((Eficiencia19) >= 0.9, "Green", IF((Eficiencia19) <= 0.7, "Red", IF((Eficiencia19) > 0.7, "Yellow"))) What it does , it automatically put a symbol, depending of the value of a cell. It does this independendly of the date. Green : >=0.90 Yellow: > 0.70 and <…
-
Column with Remaining Days
Can a column be added that can display the remaining days of a task ? and How can be this done. Thanks
-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
-
Auto fill gaps
Good afternoon, I would like to know if it is possible to autofill a gap by using a code in a formulary. For example: Code number 5678 - WALLMART STORE When the code is entered automatically a gap is filled. Is it possible ? Regards,
-
unintentional deleting of cells
My cells are being deleted simply by clicking on the cell and staying on the cell for about 3-5 seconds. How do I stop this nonsense? I have logged in an out several times. The undo buttom does repair it but obviously that is not a fix. Any suggestions?
-
Formula help please (Simple if statement!)
Good afternoon, I am having trouble with an IF statement returning a date. It works fine if I ask it to display a text column instead of the date column so I know my formula is correct. Basically I have added a column with a display on calendar or not, so a simple Yes or No drop down. If it is "Yes" display the Event Date,…
-
Customize Metadata for Rollup Project Plan
Hi Community: I want to see if anyone would know the way how to customize the metadata for the rollup project plan. I would like to add more "columns" to allow filtering in the Portfolio Scorecard when my projects rolls up into the scorecard.