-
Elapsed Days Counter - How?
Hi everyone, I'm needing to report on elapsed days for a few tasks. Anyone know how to do this? Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet. Any help is greatly…
-
Tracking latest Changes for Helper Column
Hey all I need some help with tracking the latest changes in a row for my sheet. My sheet is going to have repeating update requests to track each shifts production levels every couple hours. The team leaders will update the row with the current production number at every interval. I want to have a helper column that will…
-
Created (date) format in formuals
When using the COUNTIFS formula and referencing the created (date) column in another sheet, what date / time format do I need to use when including a specific date as criterion?
-
COUNTIFS with reference another sheet
Hello, I'm looking for the right sentence to count the lines from a second sheet how meets my criteria. This one doesn't work: #UNPARSEABLE =COUNTIFS({Inventory Asset - Africa & Middle East Range 1}, ([TYPE]1:[TYPE]56,"Physical",[WARRANTY EXPIRATION]1:[WARRANTY EXPIRATION]56, "EXPIRE IN 24 MONTHS")) I just want to count…
-
Help on formula: Monthly savings calculation
Hi, Please need your help on how I can calculate my monthly savings on completed projects. I am currently using the below formula but couldn't get it right. =SUMIFS([Negotiated/Potential Savings]:[Negotiated/Potential Savings], [Actual End Date]:[Actual End Date], <=[Summary Info 3]41, Status:Status, "completed") Kind…
-
Automated Alert & Action Issues
Hello I am trying to solve an issue with a system I have set up for Automated Alerts & Actions. See screenshots below. As you can see by screenshot 3, I have created a trigger column based on date surpassed; once that date is surpassed the cell will change from N to Y. The idea ultimately is when it changes to Y it…
-
Open-ended column on another sheet
I am using SUM referencing a column on another sheet and I want to get that column to be Open-Ended (so that when new rows are added to the other sheet, they will be automatically be in the new total on my sheet). Details: I am adding Hours from a time card sheet. When I stay on the that time-card sheet, Open-ended is easy…
-
Exclude blank "Due Date" cells from formula
I'm trying to update my "At Risk" column (Flag icon ON/OFF). I want to create a nested formula. I want the flag ON if all three conditions are met: * The "Due Date" is within one day. Example: if today is 2018-05-04 and the "Due Date" is 2018-05-03, then this condition is met. * I have a "Status" column. If one of these…
-
Do Not Count Holidays and Less than Zero
Could someone tell me how to write this Excel formula for Smartsheet? Excel: exclude holidays and leave blank if date completed is empty. =IF(NETWORKDAYS(E2,G2,Holiday)<0,"",NETWORKDAYS(E2,G2,Holiday)) Smartsheet: exclude holidays (I have a hidden holiday column) and leave work days total blank if date completed is empty.…
-
RYG Formula Help
My formula keeps coming up as Unparsable and I cannot find the issue. Can anyone spot the issue? =IF(COUNTIF(CHILDREN(), "Green") / COUNT(CHILDREN()) > 0.6, "Green", IF(COUNTIF(CHILDREN(), "Yellow") / COUNT(CHILDREN()) > 0.4, "Yellow", IF(COUNTIF(CHILDREN(), "Red") / COUNT(CHILDREN()) > 0.2, "Red", 0))), IF(OR(ISBLANK([Due…
