-
Date Formula Not Working?
I am trying to auto-populate some dates in my "Due Date" column. When a date is entered in row 5, I need row 6 to be "date" - 5 days. The formula I tried was: =[Due Date]5 - 5 But when I click enter, it just adds a " ' " to the beginning and displays the formula. Am I missing something? *Note, this is when using a date…
-
COUNTIFS with Multiple acceptable values for each range
I am trying to determine the correct syntax for a query that is looking for acceptable lists of values across two columns. I need a count of all rows that have one of three values in Column A and one of 33 values in Column B. How would I format that?
-
Separate predecessors for start and end dates
How can I set the start date based on a predecessor of row X and set the end date based on a predecessor of row Y?
-
Can smartsheet report who checked a checkbox
Dear Mr/ Ms, I'm looking for ways to organize document control in Smartsheet through check boxes if/when documents are revised by colleagues. I'm looking for a way to 'check' a box, and then in another collumn(s) report who checked the box and what time/date this box was checked, is this possible? I found that there's a…
-
Parent-Child Count distinct children under a specific date and type parent
Hi everyone, I'm trying to establish a parent shild structure that will help me count total number of distinct children under a parent when two conditions of parent are met. Below is an example grid. I'm loking for a formula that will count the number of disticnt children that are listed under parent that are Blue and…
-
Getting from Sheet Data to Chart Widget in Dashboard
Having a heck of a time deciphering what to use in order to get from sheet data to chart widgets. Unsure if I'm using reports, or sheet summaries, or formulas incorrectly. Any help would be appreciated. Example: Needing to chart # of "Order or RFQ or Inquiry" by the selection chosen, by "Region" selected. End goal being a…
-
Change date color beyond certain time period
Hello! This seems like it should be easy but I'm having trouble figuring it out. I would like to have the cells in a date column turn different colors after a number of days has passed. For example, if the date is over 30 days, I would like the conditional formatting to change to yellow. If it is over 60 days, I would like…
-
How do change the return Value from a =IFERROR(INDEX(COLLECT fomula
Hello, I have a formula that does work the way it should, =IFERROR(INDEX(COLLECT({STATUS}, {USERID}, [USER ID]@row, {Title}, "ENVISION"), 1), "Not Attended"). It does return what is listed in the status column on another sheet. If there is nothing listed then it returns "Not Attended". Perfect! Is there a way to change the…
-
Auto-Populate Hours Column
I would like for my Hours column to auto-populate with a "1" when I put a resource name in the "Assigned To" column. I have tried the basic formula but it is not returning anything when I add in a resource to the "assigned to" column =IF(AND(ISBLANK([Assigned To]@row) = false, COUNT(CHILDREN()) > 0), Hours@row + 1,…
-
Problem with my formula,working for first part but not for the last part.
Hi, My formula works for the first 10,9 and 8 but for the others i get invalid operation. the formula is below . Time criticality is a requested go live date/ current date =IF([Time Criticality]@row <= 30, 10, IF([Time Criticality]@row <= 60, 9, IF([Time Criticality]@row <= 90, 8, =IF([Time Criticality]@row <= 120, 7,…