-
IF formula for Status of Child
Hi - I'm looking for a formula that will display "All tasks complete" in the Parent Status cell, if the Status of all Child tasks is set to "Complete" (and will display "Incomplete Tasks" if any Child tasks have any other status).
-
Validating data input in a Form
I have set up smartsheets to collect data with forms for the users at our facilities. The operators check equipment and enter the data in the form. Sometimes, they fat finger it - or forget the decimal point which causes an out of spec condition and email notifications. Is there any way to validate the data and the user…
-
SOLVED - COUNTIFS Problem
Hi, I'm trying to return a status within a range when the finish date is within 7 days, I've tried a few alternatives with the latest below (using @cell) which I know isn't correct but I'm hoping I'm close. Any advice would be greatly appreciated. =COUNTIFS({RangeStatus}, [Not Started]1, {RangeFinish}, @cell <=TODAY(),…
-
sumifs with 2 dates and a rolling 12 month forecast
Hi Community, I'm now thinking about this already too long, so maybe you can help me out? It's about controlling the total amount of guarantees active within the next 12 months (rolling forecast). Every guarantee has a value, a starting date and a termination date. Setting within 1 sheet: Column1 = Euro guaranteed…
-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
-
how can i auto populate in smartsheets
I am trying to auto populate a column based on a selection I make in another column.
-
Trouble with Date Math
I have this formula in a checkbox =IF(Date1 > [Stop Date]1, 0, 1) Stop date is a date field with =TODAY() - 15 and Date is any given date. The idea is to check items where Date is in the last two weeks other wise don't check it. It does not work. If I enter a date newer than TODAY()-15 ir unchecks. If the date is older it…
-
COUNTIF Date is in the next 180 days from today
I'm trying to use the COUNTIF function to search a date column to count how many dates are within the next 180 days from today...but my formulas aren't working correctly. Failed Attempt 1: =COUNTIF([Renewal Date]2, >=TODAY(+180)) Failed Attempt 2: =COUNTIF([Renewal Date]2, >=TODAY()180) Failed Attempt 3: =COUNTIF([Renewal…
-
Help converting and excel formula to smartsheet
Hi everyone, I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :) I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00" Is there a way to use the same…
-
SUMIF
Hi all, I am trying to add a range of cells on condition that it does not contain any value that is equal to/or less than 0. for instance (12,45,24,0,65) should equal 0 and (12,24,24,10,65) give me 135. anyone to help?
