Formulas
Discussion List
-
Summary Field, Date Within Range using SUMIFSIn Formulas and FunctionsHi, I am trying to use the following SUMIFS formula but I receive a "#INVALID OPERATION" error when trying to create a Sheet Summary Field using the formula. =SUMIFS(Hours:Hours, Status:Status, "Confirmed", FinishDate:…
-
formular syntax code editorIn Formulas and FunctionsHi all, I have some complex and long formulas in my sheet wit a lot of brackets. Do you know any syntax editor which I can use to document and analyse the formulas? Should have highlighting for opening and closing brackets etc. Thanks
-
IF Function to return Yes or No depending on difference between two dates.In Formulas and FunctionsHello, I have two date columns; [First Date of Absence] and [Start Date]. I am trying to write a formula that returns "YES" if the difference between [First Date of Absence] and [Start Date] is less than or equal to 182 and retu…Answered - Pending Review 18 views 5 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Am unable to retrieve Dates from one smartsheet to otherIn Formulas and FunctionsWhile am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect ValueAnswered - Pending Review 8 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Sum of expenses of child rows in a formula rowIn Formulas and FunctionsHi I have a sheet wherein a column contains all the expenses that is basically generated from the sum of other cells in the same row. This row is indented and I wanted to know if I could have the total of this in the parent of this row. …
-
Show next pending task in SummaryIn Formulas and FunctionsHello, I am trying to show the next pending (open) task in Summary, so it will show on my Summary report as well. In the summary report I also want to show the delivery date for that task. Basically if the previous task is Completed (che…
-
How to not skip ranks and deal with ties?In Formulas and FunctionsHi all, I worked with the Prodesk on using the RANKEQ function which was helpful, but I am realizing I have records which are ties. Essentially I have a column which ranks our projects; if the weight is 0 it's "not ranked" and s…
-
Formula to collect column names if there is a "1" presentIn Formulas and FunctionsI have a pivot table that I am attempting to use in order to collect a list of all jobs that our subcontractors have/are working on. Basically, I want a roll up of all jobs that each sub has worked on. The sheets where this info is held ar…
-
COUNTIFS and CONTAINSIn Formulas and FunctionsHi! I need some guidance for a count analysis of our RAID Log (Risks, Issues, Decision). In the RAID Log source sheet, we have a column where the team selects the Project(s) the risk or issue is tied to. The Project column is set up as mul…Answered - Pending Review 15 views 1 comment 0 points Most recent by Brett Wyrick Formulas and Functions
-
How to implement default highlight color in to field nameIn Formulas and FunctionsHello, At present Smartsheet providing highlight changes for recent updates. Is it possible to add a column/field to indicate the recent changes col name in that field.? For example I want to see all the recent changes for the past 2 days…Answered - Pending Review 17 views 2 comments 0 points Most recent by hari_23 Formulas and Functions
