-
Need assistance creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. If Columns A, B, and C are blank, I want the status to automatically change to "Not started." If Columns A or B are not blank, I want…
-
Alert Someone with Past Due items with Filter
I have a SS that I alert all on Mondays of what items that are assigned to them that are past due. When they click the "Open Update Form", I would like the filter of "Past Due Items" to automatically show them only the past due items. Can this be done, and if so, how? Thank you, David
-
Start time before 8AM
I am using duration column in increments of e10m, e30m, etc. But I cannot get my start time before 8AM. I want my working hours to be 5AM - 10PM. How do I do this without making it a 24 hour clock?
-
IF OR Formula with ISBLANK
Hi I'm after a formula that will check if [Date Modified] is more than 30 days from TODAY and / or if the [Current Position] is blank enter boolean to check the box in [Update Required]. This is the formula I have but, it doesn't like it. What am I doing wrong? Nested formulas are not my strong point! TIA Cheryl
-
Is there a FILTER function in Smartsheet, which is equivalent of Filter function in excel ?
I want to find out the stack rank percentile (i.e. where the employee stands as top 10%, bottom 10% or middle 90%) of each employee in her department in a list of employees from different departments depending on what 'Stack Rank' has been assigned to that employee by her Department Head in that Department. For example,…
-
Cross Reference Countif Formula is giving Unparsable Error.
I am hoping someone can help with Countifs formula referencing another sheet. The current formula that I have works great on the master sheet. =COUNTIFS([Resolved Date]:[Resolved Date], >=DATE(2021, 3, 1), [Resolved Date]:[Resolved Date], <=DATE(2021, 3, 31)) However, when I modify on another sheet to read as what is…
-
Form fed info to build a "Final Assembly" from multiple parts
New to Smartsheet. Have 30 sub-assembles to choose from to create 50 final assemblies. Each "final assembly" is custom and unique. I would like to feed answers into a form. The answers would pull only the relevant sub-assemblies from the 30 sub-assembles so I can CHOOSE which of the relevant sub-assemblies I want in order…
-
Formula - Add "Blank" as a value in IF formula
Hi Smarties, I know this is probably an easy one, but I have been cracking my head over the last 2 days so here I am! I have 4 columns representing Task 1 to Task 4. Each column has a single Drop-Down with Not Yet Started, In Progress and Completed. On the column Health, I have symbols of Red, Yellow and Green. Basically,…
-
How to checkbox when first and second criteria match in a dropdown list
Hi fellow team members, I can't figure how to check a box when first and second criteria match in a dropdown multi select list. Please reference below. Here's an example of what I am trying to accomplish. I want the column with the checkbox to 'Check' when the all the values in the 'List of Tests' column has been assigned…
-
SUMIFS - Formula correct but not working in Sheet Summary
I'm trying to add a Sheet Summary that will look sum cell with $ based on 2 other criteria in drop down columns. It won't return any data: FORMULA: =SUMIFS(Estimated Rev $:Estimated Rev $, Probability:Probability,"P10", Business:Business, "Spare Sales") Estimated Rev $: Free Text Field range from 0 and greater Probability:…