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 mu…
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 i…
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 belo…
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({Expe…
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 …
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. …
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…
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 …
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 …
Hi- I have a {{Status}} which is a drop down containing the follow options "Not Started", "In Process", and "Complete". I have 4 columns which are checkboxes. I would like the {{status}} to dynamicall…
