-
Less than 30 days formula not working
I used AI generated formula to make the formula above. I asked that if the date in pink is in the next 30 days, to change another column to say "ready to schedule". It worked on the cell with the date in 30 days, but then it also is showing for dates well outside of 30 days. What's not connecting? thanks!
-
Pull certain rows from 1 Smartsheet to another based on checkmark indicating completion
Hi, I am trying to figure out the best way to pull limited cells from one smartsheet to another. The use case is people will take an internal exam. Once the admin checks the box that it is complete. I want certain fields to come over to another sheet where the team that delivers the completion certificates can see it and…
-
Nested If OR formula, Better way?
Hello, I am writing out a =If(or)) function right now and it will be way to long if i do it step by step and i am wondering if there is a better way to do this. So my formula is =if(or(Location@row="Place 1",Location@row="Place 2"), "USA",if(or))... I have about 150 places i need to attach to 20 different countries. Is…
-
Change Row or Cell Colour
Hi team, I have a running annual calendar of events and activities and would love to be able to automatically change the rows, or if not a row, the cell with the event names' color to indicate that the event has passed. I have columns that show event start dates and ones with event end dates, so a formula or workflow that…
-
How to correctly use INDEX(COLLECT())
I am trying to create a cross-sheet formula that pulls the data from another sheet if it meets 3 criteria. In the source sheet, I need the following criteria met: 1. "Month/Year" column to be the same as the "Month/Year of Report" column in my target sheet. 2. "Activity code" column to be "2105532" 3. "Name" column to be…
-
Formula not working when trying to build metrics sheet with a a multi-select column
=COUNTIFS({FA}, HAS(@cell, [Column2]$1, {Test A Range 1}, $[Primary Column]@row))
-
Collect value where cell with multiple value options contains a specific value
Greetings, Community! I am hoping someone can lend a hand here, as I have tried multiple options but keep coming up short on a solution. Essentially, I have two tables. Table A (Names) has a list of unique names. Table B (Events) has a list of events, where each event can contain multiple names in a cell (not contacts,…
-
Formula for Schedule Health using Status (vs. % complete)
Hello - I'm looking to set up a simple formula for schedule health column (using the drop down symbols of red, green, yellow, grey) that automatically populates the appropriate color based on the status column and end date. Example: if the status is not 'complete' and the date has passed by 1-5 days, it's yellow - if…
-
Can I auto number parent rows only?
Hello, I would like to have an auto-number created in a column called FO Number, however I only want the number created in parent rows, not their children. The number also has to line up with a separate database I use and therefor needs to start at 1886 for the first job in my sheet. eg. "VS-CL01GP407-B" will have FO…
-
Invalid Value in Date / Time Calculation
First some background, this is not a consistent outcome, and there is more than a single calculation involved. The Hypercare Ticketing system calculates SLA times and was a bear to build as it is based on Ticket Priority and time. We don't run 24 hours, so had to calculate over 'next day'. That is just the background. What…