-
Need help using NOT in a COUNTIFS cross-sheet formula.
I think I am off my game. I cannot for the life of me figure out how to use NOT in a cross referenceย formula... I have a sheet with tons of data and am referencing a status column that has four options, blank, not started, in progress and complete. I want to count every row that is NOT complete. Here is what I haveโฆ
-
Automate the Progress Bar
Hi there Smartsheet Guru's! Im trying to figure out the best way to automate a progress bar, based of 9 columns that all have check boxes. Screenshot shown:ย
-
Functions for predecessors
Are there Smartsheet functions for enumerating the predecessors of a row? I've been prototypingย SmartSheets for managing a pretty sizeable research project (multiple FTEs over several years), potentially replacing Asana for group project management. The reporting is nice, as is the combination of spreadsheet, gantt, card,โฆ
-
Deleting Cross-Sheet Reference Cache
Hello, I made some cross-sheet references and decided not to use some and tried to change their names or delete the ones I was not using. However, I noticed that if I renamed a reference to a name that was previously being used before I would receive a notice stating that the name was already in use, but it wasn't. Doesโฆ
-
Formulas for counting number of types of rows for different months/ financial years
Hi, I currently have a sheet where we follow up leads / quotes and am wanting to create some formulas, either on the same sheet or in another sheet (so user doesn't see all formulas). I have the following columns (just a few of what i have): Status (which has quotation won, quotation abandoned, quotation lost) etc. Dateโฆ
-
COUNTIF between Dates (Children) || Summary
I have a formula that is troubling me. I am trying count between two date ranges so I can count the number of shows due (between a set date ranges or set to count only the next 14 days). The forumla below is returning zero. Is it the forumnla or a setting? The screen cap below is the from the sheet I am using, hopfully itโฆ
-
Nested IF Statement to Produce a Date?
I am really struggling with complex Smartsheet formula's. I am trying to produce a start date for different action items based on the below logic (also attaching a screen shot for reference): If "Isolated or Existing Market" = Isolated, then Start Date Test = (Grand Opening) - 10 days If "Isolated or Existing Market" =โฆ
-
Number of NetDays since last event
Hi, Looking to calculate the number of netdays since an event was recorded. I have a {Date of Incident} column and a {Classification} column Looking for the number of days since a specific classification was reported i.e. {Classification}, ="Lost Time Injury". Want to be able to report this as a Key Indicator of No. Daysโฆ
-
Countifs by Month
I am familiar with =COUNTIFS({Start Date}, >=DATE(2018, 10, 1), {End Date}, <=DATE(2018, 10, 31), {Classification}, ="Lost Time Injury") Wondering if there is an easier way to get this? This is pretty tedious when you're just looking for what happened in a particular month of the year. Regards Steve
-
Number of NetDays since last event
Hi, Looking to calculate the number of netdays since an event was recorded. I have a {Date of Incident} column and a {Classification} column Looking for the number of days since a specific classification was reported i.e. {Classification}, ="Lost Time Injury". Want to be able to report this as a Key Indicator of No. Daysโฆ