-
Match does not find the id but it should.
Hi Again, I'm having an issue where I'm trying to make sure that all of the right groups are listed in my sheet. for this I'm doing a simple match and if there is a match that means that the group is there. however, for some groups it says that there is no match but when I go to the row referenced and do a "ctrl f" i find…
-
How do I use IF formula to change a color based on a percentage column?
I could greatly use some assistance with creating a formula for my sheet that would capture the following: Currently I have a sheet that contains the following data points: Quoted GP | Quoted Margin % | Actual GP | Actual GP % | GP Health $7857 35% $8970 24% ?? In this sheet, I want to be able to do the following, I have…
-
Capacity formula
I am trying to add to this formula "<+" &{end week}, Weekend@row =COUNTIFS({Name}, [Primary Column]@row, {Week}, start@row, {Year}, [Column3]@row, {SKill}, "LTE") * 60 I want this formula to look and see the end week and add 60 for every week of the project. Help columns and example below. Right now this formula tracks 60…
-
Drop Down Multi Select Formula
Good afternoon everyone. I am trying to figure out the best way to build an "IF" type formula from a multi select column. The formula I tried was: =IF([1. Line of Coverage]@row = "Voluntary Life/ADD", 1, 0). This would put a star in a column to illustrate that a document needs to be collected. This works as long as only…
-
COUNTIF Date Range with criteria
I am trying to count when Brian shows up in column "Auditor Name" but only for a specific week, dating 6/3 - 6/7. =COUNTIFS({Audit Date}, >=DATE(2024, 6, 3), DATE(2024, 6, 7), AND({Auditor Name}, "Brian Lucas"))) Where is this going wrong?
-
Formula Auditing/Evaluation
How do you audit or evaluate a formula in smartsheet? In MS Excel, you can audit/evaluate a formula to see the calculations for each step of the formula. I can't see a way to do this in smartsheet. I have a simple formula that should be giving me a specific value, but it's not, and I can't figure out why since I can't…
-
What formula will identify duplicates in a column and only keep the most recent row?
Hi there! Our staff fill out an "availability" form which populates a sheet with their availability for the week. I'm trying to create a formula for this sheet that will identify when a person has submitted their updated availability, and remove/hide their previous submissions. I assume the way to do this would be…
-
Date Comparison Unexpected result
Option 1: =IF(([Last_Updated_Date]@row - $[Last_Updated_Date]$1) < 0, "Up to date", "Please Update Before Proceeding") Option 2: =IF([Last_Updated_Date]@row < $[Last_Updated_Date]$1, "Up to date", "Please Update Before Proceeding") I am writing the result in a column name Template_Updated which is Text/Number Column data…
-
Counting event between 2 dates
Hi, I would like to know on my sheet summary, how many clients got registered between two dates, ex: between November 1rst and November 30th. My dates are entered in this format DD-MM-YYYY. Thank you for your help
-
locking row to the top
I have a sheet that gets filled with data from a form, is there a way I can lock the top row so when the form is filled the new row appears below the top row. I have the row locked but new rows from the form always appear above it. Just having the row appear at the bottom wont work for me as I want formulas in the top…