-
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…
-
COUNTIF in an IF formula
I am trying to see when a segment is fully completed. Our segments can be broken out into subsegments, and they can have up to 5 subsegments, indicated by the segment number followed by a "—1", "—2", and so on. So far for this formula I've gotten it to count how many subsegments there are, but can't get the final push of…
-
Conditional Formatting
I have 2 columns that i want to conditional format off one another. There is primary column and secondary. If the number in the primary column matches the secondary both cells go green, If they do not match then both cells go red I want this to be done automatically when a number is added into the secondary column
