-
I am struggling, quite a simple one
I have a column based on form submission, asking the question with answers yes and no as selections, I thien want to create a score in the next column based on Yes = 2 and No = 1, I cant get the function to work, so far I have created =IF([Reported MSK ill health - 6 months]@row = "Yes", "2") which picks up the Yes's but…
-
Sumif formula error
I am getting the #INCORRECT ARGUMENT SET error on my formula and can't figure out why. I am assuming it has something to do with the range, but not sure. Below is the current formula I have @Paul Newcome =SUMIF({Program Months Active}, =Date@row, {Monthly Cost}) What I am trying to do is search in the range "Program Months…
-
What am I doing wrong? Trying to count how many say not started in the month of dec 2020.
COUNTIFS({Request Tracker Range 2 - Status}, CONTAINS("Not Started") >= DATE(2020, 12, 1), {Report Request (Test Version) Range 3}, <=DATE(2020, 12, 31))
-
At Risk formula
Hello Community, I'm new to Smartsheet and was trying to use the below 'At Risk' formula given from the "Project Rollup & Tracking" Smartsheet template (image #2). I put the formula in my own created project plan, but when I went to my dashboard, the At Risk Tasks ONLY showed itemed that had no date associated with the…
-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
Clearing the Risk Flag
Hi there, I am trying to figure out a way to write a formula which will do a couple of things. If the % Complete is less than 75% 30 days from end date = At Risk flag; If the % Complete is 100% 30 days from End Date = Clear Flag If If Status "On Hold" is selected (regardless of the % Complete") = At Risk flag; If the…
-
IF(AND((VLOOKUP, convert to IF(AND((Index(Match
I am using the below vlookup but my sheet getting too big and I need to convert to an Index(Match). This works: =IF(AND((VLOOKUP(Code@row, {Master List (US)}, 13, false) = "Mandatory Training Non-Compliance"), (VLOOKUP(Code@row, {Master List (US)}, 16, false) = "2020 Q2")), (VLOOKUP(Code@row, {Master List (US)}, 15,…
-
If checked subtract using a date, if unchecked subtract using another date
Good afternoon, I am trying to create a day counter that will be counting until another date is filled. I thought nesting if formula's would work, but so far I am not successfully creating the correct formula. A screenshot below will hopefully help and here is the formula I wrote that is giving me the "Incorrect Argument…
-
Automated RYG Based on % Complete Formula Help
Hi, I'm trying to automate the RYG colored balls so they automatically change colors based on the percent complete entered. I watched a video, read through the suggestions from the community, and was unable to come up with a formula that worked correctly. Can you please help me identify the error in my formula? When I…
-
Pulling multiple rows of data in column from source sheet to a target sheet
I would like to pull multiple rows of data from a single column and populate it in a column in a target sheet while filtering. For example I have an auto updating sheet fed by API that auto-deletes and refreshes every 15 mins (No helper columns allowed). I'm wondering if it is possible to pull Trailer number by load…