-
Glitch Moves and Deletes Rows and Columns
Has anyone else experienced groups of rows and/or cells moving in their Smartsheets? It seems to happen overnight with 10-20 rows moving from the top of my Smartsheet to the bottom. This morning two columns were found deleted and Smartsheet doesn't have a revert function so I'll have to rebuild them. This has happened more…
-
Cell formula that will highlight a task expired if any of its sub tasks are expired
Hello All, I'm trying to create a cell formula that will highlight a task expired if any of its sub tasks are expired. For example if a parent task has any child tasks with due dates earlier than the one of the parent it should be marked as expired. Is there a formula available for this? Thanks
-
Right-away notifications not being emailed
I have setup a separete hidden checkbox column for each member of our team with a notification to send an email to each person when the column with their name is checked. The email is to go out righ away, when their column is changed. However, I have been changing and saving and no email has been sent out...some are…
-
Gantt rollup for multiple projects
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency…
-
Strip Time When Linking Max Modified (Date) Cell to Column with Restrict to Dates
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheets to a "Last Updated"…
-
Office 365 (Form) Web Content integration
I am trying to integration a office 365 forum web content link into one of my dash boards. But I get an htttps error but the shared link does us https. Smartsheets says it has Office 365 integration but is it only for certain tools sets within Office.
-
Capturing user/email addressing via form
Relatively new smartsheet form user here. Is there a way to create a field that would allow the entry of a name in one column and an email in a second column and have a user input multiple name/email pairs within a single web form? Essentially, we are creating a web form for training sessions and there are a number of…
-
Multiple choice questions in web form
Is it possible to create a question item where the user can select more than one answer - using the standard Shift or Ctrl keys - or some other way? I'm setting up my first Smartsheet ... Thanks.
-
Formula not refreshing when date changes - Can't tell I'm connected?
Hello ~ I'm new to Smartsheet and would appreciate some assistance. I have a formula that changes the color priority as the next action due approaches or passes, reflecting if the task is pending action from others: Rows that are marked "Done" then gets conditionally formatted to Grey (this was a workaround to not having 5…
-
Sum Values Between Two Dates
I'm looking for some help with a formula. I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights. What I need to do…