-
Automatic update of adjacent columns
I have a % Complete column and a Status column adjacent to each other. I would like to automatically set the % Complete to 100% if I change the Status column (drop-down) to complete. Is this possible?
-
Webform Email Notifications
We are using smartsheet to Nationally track data. When a webform is submitted there is a requirement to email a certain person within the company notifying them that a report has been issued and action is required. The list of different people who might have to be emailed on the report generated is very long and not all of…
-
Report Builder - What section
Hi, I'm trying to number actions on my list as 1.1, 1.2 etc, all relating to a section 1 in my smartsheet. I also have a handful of actions that I need to number as 1.6a and 1.6b etc. When creating the Report Builder however, the 'What' section doesn't seem to handle the letter, only the number, therefore any rows that…
-
Formula Help
I am trying to match a cell on our contract status report and pull that cell information into our recruitment sheet. On the contract sheet name is in the first column and contract status in the sixth column. I want the contract status to populate into a cell on the recruitment sheet by name. I was thinking that VLOOKUP…
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Formula to count back 30 working days
How do I create a formula to subtract 30 business days from a certain start date? I was trying to use =WORKDAY ([start date]13, -30) and it's not working. Note: the 13 is the row with the date I'm counting back from. Thanks for your help!
-
searching column for value to do checkbox
I'm trying to set up notifications for milestones that my team hits, looking for a specific ticket # in a column to send a notification when this ticket # is hit (for example, "Hey team, we just closed our 150,000th ticket. Amazing work, everybody!!"). I have tried using a checkbox column with formulas like the below…
-
Flag Red if under 100% or Past Due
Hello! Here is what I am trying to accomplish! In the column with the flags (highlighted yellow), I would like the flag to turn red when the Percent Complete Column (highlighted Green) is less than 100% OR if the Completion Date Column (Highlighted Blue) has a date past today's date. Please let me know if you can help with…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Count # of Open issues in another sheet
Trying to count the total number of "open" and "Waiting" issues in a another sheet =COUNTIF({Sheet - RAID Log Range 1} Status:Status, "Open")+COUNTIF (Status:Status, "Waiting") Hitting a wall, getting an error. Anyone have some guidance?