-
Struggling trying to auto check a box if a condition and max date are met
Hey there, I'm try to check a box only if "Changes Approved" column is checked, and it is the latest (max) date in the "Created " column. I'm new to Smartsheet so I'm struggling a bit to come up with a formula that works. Grr... Thanks in advance for your help, -ryan
-
Auto populate a cell when inserting a new row
Hi all, I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank. Is there a way to show this as the green ball when inserting a new row? (Image attached). I would like to do this without a formula if possible. Thanks in…
-
Complex Formula Help
Every year / half year, we need to figure out the business awarded/quoted ratio amount 18 active suppliers/factories among our 7 core categories. This helps us better understand each supplier/factories competitiveness in each category. Currently, we are manually calculating the % and it's very time consuming. What I would…
-
How do I set schedule health on row 1?
How do I set schedule health on row 1 for project level to be based on schedule health of tasks below? Based on my example below, the row 1 "Schedule health" should be "Red" based on the fact that rows 11. 12, and 13 are "Red". What would be the formula to use so that if one of the underlining rows are "Red" then the…
-
Return status of cell (blank vs. full) at today's date.
Hello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS dashboard. My test sheet is below: So, to determine whether Desk 1 is occupied or…
-
Counting time on projects with variables.
Hello. I am trying to create a formula that counts the amount of time an open project has taken. I am also trying to segregate it by priority (high, medium, low). I have tried using a sumif formula like this: =SUMIFS({Service Range 1} - TODAY(); {Service Range 6}; "HIGH"; {Service Range 5}; 0 *** clarifications *"Service"…
-
General Update on Assignments formula with Today - x
Hi all, as you may be all aware, I'm definitely not the most versed in the formulas when it comes to Smartsheets. I'm a self-study without any prior experience and I did learn a lot and can address the majority of issues myself, being thankful to you all. Now, however, I am asking for help again. I'd like to build a…
-
How to set an automatic alert when status in one (or several specific) cell changes?
Hello Community, I have a column with header "Status", and three drop down options: "Complete", "In Progress", and "Not Started". I want to set an alert so that when I manually change the status to "Complete" of one row, another person gets notified that this step was completed. How do I do that? So far, it sets the alert…
-
Created Date Formula for Forms
Is there a formula that will capture the created date for new entries on a form? Once the form is completed, I would like a column to automatically populate the day that row was added from the form so I can track response times. Is there anything like that available other than the audit log?
-
Copy Row Automation - New Row Remains Linked?
Hello, When using the copy row function in automation is there a way to designate the copied row as linked to the source row? The easiest use case to explain this function would be a Risk Register Rollup where projects maintain their own RRs and when new entries are made it sends those rows to the RR rollup. As status…
