-
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 :)
-
INDEX MATCH and IF Formula
Hi Everyone, Wondering if anyone can help please....i am trying to do a INDEX, MATCH formula based on a condition and it doesn't seem to be working. It works on Excel but not on SS I have this sheet. In column 2 I have multiple territories that are the same but each has a different date and a different title When I try to…
