-
Auto Move Status to Complete...
...when % complete reaches 100%. Has to be a way to do this no?
-
Number each question in Smartsheet Forms?
I'm using Smartsheet forms as a survey mechanism to ingest information. How do I automatically apply a # next to each question? I.e. 1) What is your name 2) What is your email, etc. We often change/remove questions so manually updating each one is a pain. Thoughts?
-
Why are selected dates displaying 1 day prior?
If I enter Jan 19, 2023 in the due date field, it appears as Jan 18, 2023. No changes have been made to the settings.
-
Team resource planner
Hi I would like to use Smartsheet to plan team resources against projects. Each member of my team should have access to a sheet specific to them where they can record the projects they're working on and the forecast number of days per week. Then I would like to be able to report on each of these individual sheets in one…
-
How do I make a Basic Cashflow Line Graph?
I have to think I am just missing something obvious, because I am having the most difficult time using the Dashboard to create a Line Graph that shows my cash flow over time. I tried using only two columns (again, this is a very basic chart) that has the dollar amount figure, and the date that the amount was recorded. My…
-
Altering logic based on previous answers
For my sheet, I currently have the following columns: "Change Reason," "Data Change," and a bunch of info collecting columns like "Department," "Manager," "Salary," etc... I created a form so that the only thing initially seen is "Change Reason," and based on option chosen, different input would come up. For example, if…
-
Auto Number Reset
Is there a way to reset the auto number to 1? I've been testing formulas on this sheet and even though I have deleted the lines it is still counting them. Is there a way to reset it?
-
Overall Project Health (Parent Row) Formula based on Children Rows
Hello! I am currently using this formula to visual task health. =IF(OR(Status@row = "Complete", Status@row = "Done", Status@row = "Approved"), "Green", IF([Due Date]@row <= TODAY(), "Red", IF([Due Date]@row <= TODAY(7), "Yellow", IF([Due Date]@row > TODAY(), "Green")))) The tasks are nestled under a parent row for a given…
-
How do I set an alert for form submissions that are from everyone else except my own submissions?
I have set up an alert already for changes when rows are added and a notification is sent to a specific person except where the 'created by' is that particular person The problem is if this person adds manual entries in the sheet they DO NOT get alerts which is great! However, problem is: when they fill the form, the…
-
Form link doesn't work in consistantly
I send our employees a link to a form they need to complete using an automated workflow. When they receive it in our company outlook account there is a hyperlink they can click on to access the form easily (screen shot attached). When they open the email in a different email account like hotmail and using the outlook web…
