-
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…
-
If the result is negative, I would like the response to be 0
Good morning, I'm looking for some help with a formula. This is the current formula I have, however would like to alter it so if the result is a negative, it would be 0 (rather than the negative number. =SUM([Total $ Amount (approved estimate-inc. deductible)]@row - [Parts $ Amount]@row - [PDR $ Amount]@row) / 75 * 0.3 +…
-
Parent-Child: Collecting Child Information
Good Day Smartsheet Community: Does anyone have a Formula that would Collect info from the Child and place in the Parent Cell? For Example: Parent Cell Result: Red, Blue, Green Child Info: Red Blue Green Thanks
-
Add logic to a form on workflow automation
Hi there, In forms, we are able to add logic to the form so that is a value is selected, an additional field appears or not depending on that logic. (e.g. we have a field that we ask "Yes or No" - if answer "Yes", nothing happens, if answer "No", then a new section will appear asking "please explain why". In automated…
-
How do i count if the cell is greater than my avg?
I am trying to countthe number of cells if the cell value is greater than my avg.This is the formula i try but i cant seem to figure it out" =COUNTIFS([Actual Build Length (Months) (Elliot)] > [Actual Build Length (Months) (Elliot)]1)" Any Suggestions?
-
Formula to reference two values to return a third?
Hello everyone, Hoping someone can help. I am wanting to create a formula that, based on existing criteria in two cells, will dynamically return the value in a third cell. From my "Aggregator/Calculator" grid (screenshot below), from the "Health" column at the far right, I need to return six symbol indicators each to their…
