-
If Comment is not blank, then show the recent comment and date
Hi everyone, I have a Follow Up Date column and a Comments column. I have predetermined dates under the Follow Up column. I would like a formula to populate the most recent Follow Up Date and the corresponding Comments on the parent rows only if the Comments are not blank. Any help is appreciated! Thank you!
-
RAG Status by Percentage Complete and today's date
Hi Query I have a formula for RAG status which I've been using to manage performance across multiple projects looking at the columns end date, % complete, and referencing today's date. However it is not working as planned and wanted to ask for some help please. I would like the formula to simply change the RAG status for a…
-
Easy way to express Monthly Data
Hi all, I have started a project to use Smartsheet to track Right First Time across several departments. As part of this I want to track the data on a monthly basis. The form uses a 'Created date' field to input the date when the entry was submitted. Is there a way of expressing the date, so I can use it as a COUNTIFS…
-
Nested If statemens
I've read various posts on the forum and have been able to fix a few of my issues but I can't seem to get past this one. To show the stage of a project is in a workflow, I am using various IF(AND(NOT(ISBLANK, meaning that stage has been completed. So, if the Outreach stage is complete, it will not be blank, etc. In my AND…
-
formula running the status column
This is the formula in status. The issue is that if the date is TODAY either in START or in END Date column the status turns to NOT STARTED. I need the status NOT STARTED only to show up when the start date is in the future =IF(Level@row <> 0, IF(Level@row <> 1, IF([End Date]@row = "", "", IF([Canceled?]@row = true,…
-
How to add new criteria to my current COUNTIFS formula?
Hi all! Not sure how to add the criteria do not add to count if cell = "Topic" to my current COUNTIFS formula. Current foluma is: =COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HAS(@cell, "IBX Customer Ops")) I need to add 'AND if the the "Deliverable" cell does not equal "Topic" '. Thanks in advance :)
-
Summary Sheet formula to count status by assigned person
Hi All, This should be a basic formula but I cannot seem to make this work for me and I am hoping that someone in the community can help me pinpoint where I am going wrong? I entered this in the sheet summary field - =COUNTIFS({Range - Standard Author}; StandardAuthor@row; {Range - Status}; "In Progress") noting the…
-
Start Date and End Date Form Entry Restrictions?
Good Morning, I know this is purely for cosmetic purposes in terms of putting the correct date in start and end. However, I was wondering if there was a solution to this problem using logic tab in the form section. My Users keep currently getting confused and putting there "End date" as the "Start Date" and the Start Date…
-
Date/Time Stamp Option
While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not scale very well as is. If you have a lot of rows you are wanting to track a lot of changes…
-
AUTOMATE PROGRESS BAR BASED ON MULTIPLE CONDITIONS
Hello, I am trying to automate my progress bar, basing it's progress on multiple conditions. I have 10 columns I would like the progress bar to consider. Example below of how i would like it to work: If Cost 1 AND Hours 1 IS NOT Empty then progress = 25% If Parts AND Survey AND time IS NOT Empty then progress = 50% If…