-
Need Help with IF and IFERROR
Hello, I have the IF part of the statement working just fine =IF([NEXT Month Quarterly from Today]@row = [NEXT Month Quarterly Due Number]@row, "Yes", "No") - basically it is evaluating if the next month from today is the same month as when the next maintenance is due. In rows where there is not yet data I am getting…
-
Formula help - difference between two form submissions based on a couple of
Hello, I need assistance with creating a formula to calculate the time difference between two submitted forms. One form is submitted when a person checks in, and a second form is submitted when they check out. I'm seeking a formula that considers the date stamps in relation to the Site Address and Check-in Action columns.…
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
-
Fill in Pricing based on condition of a cell
Hi, I am trying to have a cell fill in pricing based on the size of a sign. so if it is a 22x28, it should be $100. The column with sign type has different drop down options... 22x28, 44x18, 110x100... and depending on what drop down is chosen there the cost should automatically be filled in. Also not sure if it is…
-
Trying to create helper column that pulls cell based on current month
I have tried a few things now, looked around through numerous articles - but I cannot seem to get this to work. I need some metrics to auto-update each month on a dashboard, and so what I have at least determined so far is that if I can have that metric point to the same field (to avoid manual updates every month), but…
-
IFERROR, NETWORKDAYS, and MATCH all in one?
Is it possible to have a formula that includes IFERROR, NETWORKDAYS, and MATCH? I'm working with two different sheets, both of which have a start date and an end date column, along with a project ID column. In a third sheet, I need to reference the start and end dates of both sheets using the NETWORKDAYS formula to…
-
Formula Help
Hi, I am trying to find a formula that finds the closest project board date following a milestone date. From the screen shot below I want to look at the dates in the second column and find the next board date from the cell highlighted in the finish column. Is there a way smartsheet can do this or will I have to do it…
-
SUMIFS referencing another sheet and [column]@row
Hi I'm trying to sort the data exported from Resource Manager into something I can put in my budget. The formula I'm trying is: =SUMIFS({Import sheet Range 1}:{Import sheet Range 1}; {Import sheet Range 2}:{Import sheet Range 2}; [Fas]@row; {Import sheet Range 3}:{Import sheet Range 3}; [Roll]@row, {Import sheet Range…
-
COUNTIFS / OR - INVALID DATA TYPE
Looking for your help, I'm trying to get the below formula to work. Let me know if you need additional information: =COUNTIFS({Albaugh, LLC - RICEFW Tracker Range 4}, [Primary Column]@row, {Albaugh, LLC - RICEFW Tracker Range 3}, "Release 1", OR({Albaugh, LLC - RICEFW Tracker Range 5}, "Yes", {Albaugh, LLC - RICEFW Tracker…
-
Change first day of week to MONDAY, instead of SUNDAY
Hello! I found that in 2015 there was a request to give users option when the week should begin. In some countries it starts on Sunday, in some on Monday or Saturday. However the dropdown menu is still the same after 7 years. Or is there any option that I've missed? Best regards!