-
Help with Nested Formula
Hello, I've got the below formula to sorta work, but the problem is that it is not giving me a return if my value falls outside of the last formula (>500). I even tried the second formula, but it put everything to 5 no matter what. See screenshot below (1st formula). Thanks in advance. =IF(Lipemia@row < 40, "0",…
-
How do I show a holiday in a date range?
I know how to add holidays into my project settings so that Smartsheet automatically adds another calendar day to the timeline. Now I want to show the name of the holiday that falls within a date range on my project plan. That is, if I have a task that starts December 20 and ends December 27, is there a way to indicate…
-
how do I automate workflow based on a check box?
Hi. I have a sheet the checks and unchecks a box based on inventory levels; when inventory drops below a certain number the box is checked and when it rises above that certain number the box is unchecked. Next, I created an automated workflow that is supposed to copy a row to another sheet when a box is checked but for…
-
Why does my Index/Collect Formula stop working after 8 rows?
Hello, my formula stops working after it gets through 8 rows. I have a picture below where I'm just testing out 30 rows but I need this to work for about 4000 rows, however I can't figure out why it gives me an error after awhile. This is my formula. =INDEX(COLLECT($ItemCategory$1:$ItemCategory$30, $[Date Order]$1:$[Date…
-
I am trying to have a column to show me the next date of a given month and day.
For example, I have a column that has contract renewal dates. These would be Jan 1 Aug 1 September 1 December 1 Etc … I would like the column next to it to figure out the next date based on todays date. If today is August 28, These values would be: Jan 1, 2025 Aug 1, 2025 Sept 1, 2024 December 1, 2024 Is this possible?…
-
Hi All, new to Smartsheet's looking for some assistance on a formula not sure which one to use.
I am currently using the Index Match to pull data from one report to another and the identifier is the email address. The issue I am having is the reference form I am pulling from will have Team Members on the report twice on occasion if they are a rehire. They will show once as active and then on a different line once as…
-
How can I identify the earliest date for each of 5 criteria in another column?
Hopefully I can explain this and it make sense! I’ve done some googling and tried various things but don’t feel like I’m on the right path… I have a sheet with multiple columns of data, including a Manager column (Contact List) and Date of Last Update (Date) column. The Date of Last Update is updated via workflow when a…
-
COUNTIFS function with multiple criteria
I have what I think should be a simple formula, but I only get "#UNPARSEABLE". I just want to return a count when the WAVE column contains "Wave 2" AND the STATUS column contains "Not Started". My current formula is: =COUNTIFS({Wave}, "Wave2" AND {Status}, "Not Started")
-
Hello! I'm New to Smart Sheets and the Community!
Hi All! I'm working on a sheet/form to allow my team members the opportunity to apply for daily early outs if permissible. What I'm looking to do is to auto populate their hire date once they submit their email on the form (from a drop down list). We have approximately 800 team members so I was looking at the best/easiest…
-
Trying to create a Level to CEO hierarchy without any success
Hi there I am trying to create a formula to return a value of 0, -1, -2, -3 etc. depending on the employee's level to the CEO. It's easy enough to get the first two levels where Direct Manager = 10002 then Level to CEO = -1, but how do I get anyone reporting into the -1 group to have a -2 and so on until -5? Thanks and…
