-
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…
-
Show my "next deliverable date" based on the child-parent task relationship?
Hi! I've been using the MIN and MAX children functions to roll up dates from child tasks, or sub-tasks, to the parent task. I also want to create a column that looks at the dates of each sub-tasks and grabs the one closest to today's date that has been marked as a deliverable so I know the "next upcoming due date" among a…
-
Formula to Exclude Blank Fields from a Workflow Alert Message?
I have an automated workflow setup to alert someone when a new row is added and specific criteria is met, however, I want to customize the alert message to only include specific fields if they aren't blank. Is there a way I can setup the workflow criteria with a formula so that that the message being sent will exclude…
-
IF certain columns are not blank then autofill another column based on this?
Hi, I want to autofill a column [Column 1] based on whether a number of other columns contain text/date, i.e. IF [Column 2] is not blank then put '-' in [Column 1] IF [Column 3] is not blank then put 'P1' in [Column 1] (this would override above) IF [Column 2] is not blank then put 'P2' in [Column 1] (this would override…
