-
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β¦
-
COUNTIFS for multiple values in a column, as well as individual values from other columns.
I'm trying to write a formula that counts the number if items John has deployed in a sprint with a Work Type of Configuration Change, Quick Win or Stat Change. I'm getting the data from a separate sheet, and the column names are Primary Assignee, Sprint, Status and Work Type. I tried =COUNTIFS({Primary Assignee}, $John$1,β¦
-
Looking to Avg a Parent with 2 columns of averages
Hi I am looking to average in the E%Allocation column when the level column = 3 for the averages in columns ChildAlloc1 and ChildAlloc2. Any suggestions is greatly appreciated.
-
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β¦
-
IF Formula and Auto Numbering
I'm looking to use the below formula however I get an 'INCORRECT ARGUMEMT' error message: =IF(Type@row, "Form", "F-" + [Auto #]@row, IF(Type@row, "Report", "R-" + [Auto #]@row)) Additionally, I'm looking to add this funtionality to a sheet that already has some R-XX and F-XX entries, and looking to automated the numberingβ¦
-
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β¦
-
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,β¦
-
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β¦
-
Can't see what I am doing wrong
Hello wonderful smartsheet users and apologies for a question that may not seem like it needs to be asked but I keep getting unparsable error for my cross sheet formula and i just can't see my error. I am trying to have Program name entered on my target sheet if the status on primary sheet says "approved"β¦ this is 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,β¦