-
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…
-
Enter dates automatically from colums selection
Hello, I am trying to have dates enter automatically based on column selection. In the example below, then the column says yes, the dates are blank. When the column goes to"In Process," the date is recorded in Milling SD. When the column goes green or "Completed," the Milling ED is recorded. Is this possible? Thanks,…
-
How do i count the cells that are greater than my average?
=COUNTIFS([Projected Build Time (Months) (Elliot)]5:[Projected Build Time (Months) (Elliot)]91 > [Projected Build Time (Months) (Elliot)]2) I recently asked this question but i have since changed some of the details on my sheet and i cant seem to figure out how to get my formula working again? I am trying to count the…
-
Another Formula Question
Good Day all, I am having another issue with a nested "IF" formula. I have 5 columns that are drop down selection. They each have 3 choices. "Approve", "Approve - with changes" and "Not Approve". I am trying to get a status column to return "Approved" IF all 5 columns state "Approve or Approved - with changes" and if any…
-
Need help to adjust automatically my Order Date using Date Formula
Hi, I have two date columns in my sheet 1st column is "First Order Date" and the next one is the "Next Order Date" with underlying formula of =[First Order Date]@row+ 30, we need to supply our clients every 30 days. The problem here is that using that formula "=[First Order Date]@row+ 30" will give you all the day in a…
-
Multiple contacts in one cell count
Hello, I am looking to count a specific contact within a cell that has multiple contacts but I would also like to ensure the count is for a specific criteria. For example Joe Smith and Jane Doe are in the same cell but I want to count how many times Joe smith appears in the smartsheet while also ensuring he is meeting an…