-
Collecting dates prior to today
Hello I'm fairly new to actually using formulas on Smartsheet but its been a great tool thus far in what I've been doing, I have a question regarding making a weekly rolling number formula, if that makes sense. I want to take one columns information specifying a targeted area in the column and then reference another…
-
I am trying to write a formula to Identify departments that have not reported
I am trying to write a formula that will display departments on a dashboard that have NOT updated a value at any given time. Basically, in this Scenario, If the Stamping dept has nothing logged in labor hours, I want Stamping dept to populate in a Dashboard as "non report" of sorts. I have tried using an =IF formula on…
-
Return a Parent Value if All Children Values are the Same
I am trying to have a parent cell in one column return the value of the children cell in another column if all of those children have the same value. I thought I could have the cell check the first child and then see if all the rest matched. If they did, that means they are all the same, and the formula would return that…
-
Time Spent (DAY)
Hello- Can you assist me with my formula? I need to add in my processing time (Days) column, the Date Recorded Linked. So basically, I don’t have Date Recorded Completed if I have Date Recorded Linked and vice versa. Do I need an OR formula? =IFERROR(NETWORKDAYS([Date Started]@row, [Date Recorded Completed]@row), "")
-
Index Match
Hi there, I need help with creating a formula for using Index Match What I want to formulate: If California is selected from the State column dropdown, I want it to index match and reference another sheet to pull record # based upon email. (Bar Number CA is the same as Record #) Current formula:=IF([State Column]@row =…
-
Status Change Formula Unparseable
My sheet requests dates at certain milestones which should change a status from 1-10. My formula is not working and I think it is likely a syntax problem. Can someone assist please? =IF([10. Date of Closeout (Kayla)]@row,"10",IF([9. Date Invoice Received (PM)]@row,"9",IF([8. Date RR is Received (PM)]@row,"8",IF([7.…
-
If Has on multi select with an Index/Match
trying to get this to work.. but failing on correct syntax. =IF(HAS("California", State:State), , IFERROR(INDEX({DS-Record #}, MATCH([WSGR Email]@row, {DS-Email}, 0)), "")), IF(HAS("CA", State:State), "") ultimately, we have a multi-select option on the form, if they select multiple states we want it to look up their bar #…
-
Auto-populating a Form
Hi, I am trying to add more data to my form by auto-populating with the below formula: ="https://app.smartsheet.com/b/form/648c11b98a0847d187a13ed81133bba7" + "?BARCODE=" + BARCODE@row + "&PATIENT%20NAME=" + SUBSTITUTE(SUBSTITUTE([PATIENT NAME]@row, " ", "%20"), ",", "%2C") This formula populates the form with the data in…
-
Nested IF/INDEX/COLLECT
Hello, I’m looking to add to an existing formula. The formula below checks if the Country and Instructor Currency match and pulls in the Fee if it does match, or the Converted Fee if it doesn’t match. The formula also matches the Instructor Name, Course and Format match. This has been working great where I have an…
-
Formula Assistance - VLOOPUP, COLLECT, INDEX???
I have a survey intake sheet that contains Project Managers and Type i.e. Managed Services / Professional Services I'm trying to create another sheet that automatically pulls in the below info from the intake sheet: And don't know if I should be using a VLOOKUP, INDEX, COLLECT I need the formula to be able to add the…