-
Formula to Summarize spending each week to display in a Dashboard
Hello, I have a large sheet that we use for procurement for our company. Employees use a form to requisition items, and then when I place the order for them I input the date ordered into a column. Another column tracks the cost of each order. I would like to have a formula that uses the "Ordered Date" column to add up the…
-
IF OR Statement
Hi There! Looking for help to on an IF OR statement. Want to take two columns that will be either Yes or No, and populate another column with a date from two columns if it is Yes. Process, either the Facilitator or the Architect will be requesting a Complete By Date. Whichever requests, the other has to say yes or no. For…
-
IF Formula for Today's Date between Two Dates
I'm trying to create a formula that is only triggered when today's date is between two dates. Otherwise, I want it to be blank. I want the dates to be in the cells and not just in the formula. I use this year over year and it will be a lot faster to change them for next year. I get Invalid Operation when I use the dates in…
-
Extracting Data from Multiple Sets of Brackets IF present
This formula is working great for rows where the criteria fits - but my first problem is: can it be an IF statement so rows that dont have brackets are just blank? I cant seem to make it work? Second and third problems are, how can I parse the second and third sets of brackets into their separate cells for the same…
-
How do I pull dates from one sheet to populate onto another sheet based on an address
Good Afternoon, I am novice to Smartsheet and require some assistance. I have a sheet- let's call it Sheet A-that has a form linked to it. My colleagues complete this form when they go visits sites, and the information auto-populates onto Sheet A. I have a second sheet-let's call this one Sheet B. I copied and pasted all…
-
Max number pulled from the ID
Hi all, I am looking for help with creating a formula which would give me the max number (based on condition) from combined ID? Example of ID's RTR_I_053 TPM_I_012 FTS_F_009 The condition would be if the ID contains example "_F_", give me the highest number for this item. I tried =IF({Ref to ID column}, CONTAINS("_F_",…
-
How do I get Working Days remaining to stop counting once a task is complete?
I'm using a SS template that has start/end date, working days remaining, duration, % complete and status. If I mark a task 100%, it automatically changes my status to "Complete". It's a nice little automation. What I'm noticing though is that the working days remaining field continues to count and I have a "-" (negative)…
-
Flagging Duplicates with Multiple Criteria
Hi all, Trying to identify when I get a duplicate that meets both criteria, when the Work Order Number is the same and when the Service Area is the same. I'm using the following formula, =IF(COUNTIFS([Pass Number]:[Pass Number],[Pass Number]@row,Site:Site,Site@row)>1,"Duplicate","Not Duplicate") But its not working…
-
Hello! How can I work an OR statement into this formula? I need it to look at 6 different columns.
=IFERROR(INDEX(COLLECT({Provider being reviewed}, {MRN 1}, CONTAINS(@cell, MRN@row)), 1), "")
-
Using the Copy Rows Function Within A project Template of Sheets
I am having an issue when I am trying to move a row of data to another sheet within the folder structure of a Workspace. When saving the workspace as a new workspace (for a new project for example), the sheet containing the automation to copy the row to another sheet continues to point to the original sheet, and not the…