-
Importing Dates
I am importing a manufacturer's shipping report into Smartsheet with Data Shuttle. If the product has not shipped, the manufacture has a date of 00/00/0000. When I import the data, I want the date to be blank, if the date equals 00/00/0000. How can I make the cell blank if it the date imported is 00/00/0000 ??
-
COUNTIF, one cell is text, and one cell is 'check box'
@Kelly Moore I have a summary formula that works to count a cell if there is text in it, works good, can weed out the Data that I don't want to count with other summary formulas. However there is often preplanning or left over data. My solution is to show the [route] completed [done]. =countif([done]:[done],1) works…
-
Can a Workflow Cancel a Remaining Requests for Update if 1 of 3 people update?
I have a use case where we dont want to use request for approval because it writes an additional column to the sheet, we are currently using Request for Update to utilize the row form to assign a project task. When a row is created, it sends a request for update to assign a task to three people. Once one person completes…
-
Can you create an IF Statement using the following?
If Actual Build Date is Blank, Clear to Ship is Blank, and Actual Ship is Blank, then put "Not Started" If Actual Build Date is Not Blank, Clear to Ship is Blank, and Actual Ship is Blank, then put "Factory" If Actual Build Date is Not Blank, Clear to Ship is Not Blank, and Actual Ship is Blank, then put "Clear To Ship" If…
-
Nested IF(AND(OR)) Formula
Hello! I'm trying to write a column formula that will return project task Status "Study review Complete" if the particular task is complete else should return "Study review incomplete" otherwise. My formula needs to read across 2 columns, and one column is a dropdown list and other is a checkbox. -- I want to show status…
-
Formula that ignores blank dates
I have 4 date fields, Target Start, Actual Start, Target End, and Actual End. I need to turn the cell yellow if the date is out of sync but handle that some dates can be blank or equal. • I may have a Target Start date, but not have an Actual Start date, Target End date, or Actual End date yet - which is OK and should not…
-
Using Checkbox to Set the value of a second checkbox in same sheet
I have searched for awhile and have not found a solution. I have two columns. [Waitlist] and [Waiver Granted]. Both use Checkboxes. For this subset of data, [Waitlist] is generally true (checked) for each row. I want the user to be able to check the checkbox in the [Waiver Granted] column in one row and have it…
-
sum of hours based on weeknumber
I have project hours and dates and this summary formula works well: =SUMIF(PressDate:PressDate, TODAY(), (PressHours:PressHours)) I also have a weeknumber formula on the sheet =weeknumber(PressDate@row) for the weeknumber of the press date and on the summary =WEEKNUMBER(TODAY()) to calculate the weeknumber based on today .…
-
COUNTIFS Formula help in sheet summary
Hi, I currently have one field in my sheet summary which calculates the current project week. I also have one which calculates the number of tasks in the current week with the below formula, linking a column to my summary field showing the week number tasks are completed: =COUNTIFS([Projected Week Work…
-
Help with setting a symbol color based off calculation
Hello, So I have two columns. Actual and Budget I want to calculate the difference between the two, and then if the difference is lower than the budget number, the indicator symbol would be green, else if it is higher, the indicator symbol would be red. Thoughts on how that would look in a formula. TY
