-
What is the longest formula you've created?
As the title suggests, I am very curious to see how far some of you all have pushed the limits of Smartsheet formulas. I think it will be interesting to see everyone's longest formula, and what they created this formula for. I'll go first: A person on the Smartsheet community was requesting a column to have employees names…
-
Smartsheet users in The Netherlands
Hello, We're using Smartsheet in our R&D department to manage product development. In order for us to make a next step in using Smartsheet functionality and building more complex dashboards, we are looking for Smartsheet users in The Netherlands or Benelux. Please reach out to me if you are or know someone. Thanks, Rob
-
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…