-
Expired Date code
So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But =IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction. And i try this code, but i…
-
SUM Count of children Checkboxes
Hello, I am trying to add the children count of several columns but I just have a 0 as a result of a simple =Sum() formula.
-
Automation: Request an update but my contacts are not in a contact column
How can I work around this issue. My sheet is populating the "Contacts" via formula. I want to trigger automated update requests but am running into issues since I'm unable to convert the column type to "contact" since it appears that Smartsheet doesn't allow this functionality. Anyone have any ideas how I can work around…
-
Automation: Request an update but my contacts are not in a contact column
I'm working on a sheet that has a formula that is running an INDEX/MATCH to populate the Carrier Contacts based of the trucking company's Unique SCAC code. The fomula is working great now and I have the cells populated with the email contacts for the carriers. I am now trying to write an automation "Request an Update" but…
-
Date Dependency
Hi, Our ERP system exports tasks and the materials needed for those tasks with the same task ID number. We schedule based on the actual task and predicted duration. Is there a way to automatically assign the same start date to the materials needed for the tasks based on the scheduling of the actual task? Screenshot…
-
IF Statement
How can I combine the following two formulas in one statement: 1) IF([Patient Date of Birth]1 OR [Last Patient Visit Date]1) = BLANK OR NULL) THEN ([Patient Date of Birth]1 AND [Last Patient Visit Date]1) = "1/1/1940" 2) IF(NETDAYS([Patient Date of Birth]1, [Last Patient Visit Date]1) / 360 > 12, DATE(YEAR([Last Patient…
-
Max Function
I have a formula that finds and returns the maximum of a set of date cells meaning that it finds the latest date. It works fine if all cells are populated with dates but if one cell is blank it error out. This is the formula: =MAX([Due Date]1, [Family Member A Due Date]1, [Family Member B Due Date]1, [Family Member C Due…
-
Nested COUNTIF formula
Hi! I am hoping someone can help me solve this formula. What I am trying to do is keep a running total of hours of vacation used. For example, If Joe wants to take an 8 hour vacation he will go to the dates and type in "V8" (Vacation, 8 hours) or 4 hours would be "V4".ETC. When this is entered I want those hours to be…
-
IF Planned Date is Still blank leave RGB Status Column Blank
Hi, If you could please assist with the formula below? The formula works perfect, except for when no date is entered in the Planned start date. Currently when no date is entered in the Planned start column the RGB ball stays "Red", and i would like it to show "". Current formula: =IF([Kick-Off Meeting Actual Finish]1 <>…
-
Most Recent Date
Hi everyone... I've been struggling with how to do the right formula here and would love if anyone could help. I have a form which people are to fill out twice a month to do a temperature check on their progress. The data will have the date, name, etc., then their "mood" (a dropdown list), and each entry will be a separate…
