-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
TotalFloat with multiple phases
Hello, are there recommended best practices for handling dependencies when calculating TotalFloat, =TOTALFLOAT([Primary Column]@row)? In this example, Milestone 0 requires that Tasks 1-3 be completed and is a predecessor for beginning the next project phase. TotalFloat calculates values for tasks 5 & 6, but it does not…
-
Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
-
Can Only reference a total of 100000 cells (combined) from other sheets. Please select fewer cells a
Hi All I am a newbie to Smartsheet, been working on it for a few months only. I am getting this error. Google is not helping me much. Please can a good samaritan assist me in this forum? Thank you so much. Existing formula that I am trying to update =COUNTIFS({Archive Sales Stage}, [Primary Column]@row, {Archive BU},…
-
Subtracting Days & Months from Specific Dates Using a Separate Day/Date Column.
Hello all, I am having some trouble trying to use the correct formulas to subtract both Days and Months from certain dates. I am also incorporating a helper column that would allow me to change the days or months if needed. Hope this makes sense. I have also attached a screen shot of the table I am working with at the…
-
How Do I Contact the Smartsheet Support Team?
Hi Team We are using Smartsheet in our Organisation and urgently need assistance with some formulas which are giving us issues. I am not sure who to contact please, can someone assist me? Thanks so much Benie
-
Index Match not working
Hello, Smart community! I have something that seems VERY simple that just doesn't want to work. I'm using Index/Match. The sheet I'm referencing has a Primary Column (QMS) with a numbering system to identify if it is a Risk (R) or Opportunity (O). I have put in 17 rows of "R"s (i.e. R01, R02, etc). The sheet I'm trying to…
-
Formula to calculate 'status' based upon % Complete and a Checkbox
On a project plan, we have a column for “Task Not Applicable”, and we have an automation rule that when this box is checked, the “% Complete” field changes to “100%”. When the box is checked, the below formula changes the “Status” field to “Complete”, instead of “Not Applicable”. Can you help me write the formula so that:…
-
COUNTIFS with AND/OR
Hi, I'm trying to count the number of sites that have PNS and are either Experiencia, Experiencia Plus or Experiencia Plus Unlimited. This formula is giving me an UNPARSEABLE error. =COUNTIFS(OR({Experiencia Tier}, "Experiencia",{Experiencia Tier}, "Experiencia Plus",{Experiencia Tier},"Experiencia Plus Unlimited"), {PNS},…
-
Display 2 dates in one sheet summary field
can I display both a start date column and end date column value in ONE sheet summary field IE start date column in sheet 11/7 end date column in sheet11/14 Sheet Summary field 11/7-11/14 Help please :)