-
Need the minimum start date for projects, what's the formula?
I'm trying to get the formula for the min start date based on the project number. So in the chart below the minimum start date for project 1 should be 11/5/24.
-
Combine Multiple IF statements
Hi! I am trying to write a formula that returns "Yes" when all expressions are true. I have written four IF formulas, that work independently but cannot figure out how to combine them. My final formula will not move past the first expression. Here are my criteria: IF Procurable is Yes, TBD, or Blank =IF(OR([Procurable]@row…
-
Count # of cells approaching a date for sheet summary
I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell. This is what I've tried: =COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7) Thank you for any help!
-
Variance on time or behind schedule collumn
hi, can anyone help me create a column that tracks if my variance column is above or equal to 0 then return a value of “on track” if the value is below 0 then return “behind schedule” BUT return a blank value if the variance column is blank.
-
Index(Collection formula for dropdown field with multiple entries
Hi Team, I know I am asking a lot but if anyone knows it will be this group :) I have a dropdown field that allows multiple entries - for example sales blockers These blockers can be grouped together to give a blocker group. I've used =INDEX(COLLECT before but not sure it will work for multiple entries any ideas if I can…
-
can i auto-populate/create rows on another sheet if a cell on another sheet changes?
In this case, I'll populate a scheduling sheet as seen on top, this will then ideally show up on the 18th of Dec (if it's scheduled on the 18th) as separate rows if possible. Not sure if smartsheet is able to do something like this so would like to get possible help or input? So far i've tried using smth like…
-
Is there a way to capture the latest comment on a sheet?
In a project schedule sheet, where comments are made on rows/tasks, I want to grab the comment that was made last on that project sheet to use in a summary report. I know you can view all the sheet comments, but I only want to capture the last comment made on the sheet. Goal is that the summary sheet will always have that…
-
2025 Free Smartsheet Webinars/Office Hours
I hope everyone is having a great start to their year! I am posting here because I wanted to share the schedule for the Smartsheet Webinars we will be hosting this year. Here’s a breakdown of the schedule for the first half of this year: Office Hours: Starting in February, our Customer Success Manager, Lisette Planken,…
-
Formula for numbering rows based on specific conditions
Hello! I need to create formulas for two columns that number rows based on specific conditions. I have a helper column (Number). First, I want to number rows that: Type is "Focus Group Volunteer" and Internal is "yes." Second, I want to number rows that: Type is "Focus Group Volunteer", Internal is "no", and Patron Type is…
-
Auto fill form for status updates
Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - if applicable. This value needs to be pulled from a sheet based on the region/function…