-
is there a way to make children auto-calculate percent complete based on start/end date and the curr
I'm new to this program but not scheduling in general. Is there a way to get each child beneath a parent to calculate % complete automatically, based on the entered start/finish dates and the current date? I'm building construction schedules, and don't want to have to manually update huge amounts of child rows, especially…
-
multiple date columns
i have created a sheet that has a notification date column and then a start date column and then an end date column. i only want the ghant chart to pick up the start and end date columns and not the notification date column. how do i do this???
-
Static Date/Time Time Stamp formula
I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day. =IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 = "SERVICE COMPLETE"),…
-
Audible alert
Does Smartsheet have an audible notification feature? For example, if I have the smartsheet open, yet minimized on my computer, and someone makes an entry, is there a “ding” sound that would tell me that an entry was made? Or if I have smartsheet open on my phone, and an entry was made, would my phone make a “ding” sound?…
-
Date and time stamp updated by day light savings
We have a number of Smarttsheets that are populated by web forms. The date and time stamp information that was entered prior to day light savings have now changed to reflect a "fictional time". In other words, an entry that was added at 6:00 am two weeks ago, now show a 5:00 am entry time. We need the historical…
-
Editing Conditional Formatting Rules
Hi, Is there any way to edit the rules in conditional formatting? For example, if I have a rule that has 10 conditions, is there any way to go into the rule and delete one of the conditions? Example: If column 1 is 'yes' and column 2 is 'in the past' and column 3 is 'blank' and column 4 is 'not blank', and i wanted to…
-
User with Admin Permission not able to edit Sight?
Hello! I've created and shared a Sight with an end user and have provided Admin permission, however they are not able to save any of their changes when they try to edit the sight. The error message says "You do not have sufficient permissions on this Sight to make this change." Thanks, Nick
-
Cell Change Counting
Hello, Is there a formula that will count the number of times a cell changes? Thanks, Rozan
-
Counting current months in a date column
Hello, I am trying to get a count of due dates in the current month, here is the formula I am using and it always returns zero. the formula is in a text/number column and the data is in a date column. =COUNTIF([Due Date]3:[Due Date]204, MONTH(TODAY())) I,m a beginner and could really use the help. not getting errors, just…
-
Use Today's Date by Default in Web Form
I've created a task list which I enter tasks via a web form. I have a Date Entered field in the web form. I would like to make this a hidden field in the web form and by default enter today's date into my task list when I submit the form.