-
Hello, I have the following formula that works but I want to adjust it to working days only:
=SUMIFS({QTY produced}, {completed date}, <=TODAY(), {completed date}, >=TODAY(-30), {element}, ([description reference]@row)) This formula is pulling completed dates from another sheet. I am wanting the formula above to only count quantities 30 working days from today's date. Is there a way to modify this formula toโฆ
-
If statement referencing another sheet - Outcome Employees that have not submitted their time.
I am trying to capture employees that have not submitted during a week. I have a sheet (Staff that hasn't submitted) with all the employee names and a yes or no column. I would like to ref the master sheet (Standardized Time Sheet) which also has the employee name and the week ending date which is always a Saturday.โฆ
-
How to Add period only if there isn't one already?
Hello i am currently trying to use a formula that will take a name from a cell and add a period to it since it it the end of the sentence. This is the formula i use. =[Name]@row + "." The problem is, is that some of the names have periods already at the end because its words like Inc. or LLC. so how would I make it add aโฆ
-
Forumla to add a date
Hello - I'm trying to write a formula to add a date in a cell if a checkbox in another cell is not checked, like the image below. If there is a check in "transfer to tier 2" I want closed to be blank, if there is not a check, I want it to have the date the row was entered. Can anyone assist? I've looked at automations toโฆ
-
Parse Out Number Values in Successor Column
I have found multiple threads on this but I can't seem to get any specific formula to work for me. I have a column to Join Successors =JOIN(SUCCESSORS(Name@row), ",") The highest number of Successors I have is 4 and I'm trying to parse them out into separate columns. I have formulas that work for three but can't figure oneโฆ
-
Populate multiple cells in sheet when code matched in another sheet
Hi, i'm totally lost on this one and hope the community can help. I have 2 sheets, 1 and 2. Sheet 1 has column called "code" (unique ref number) and other columns 'color', 'size', 'cost', 'weight', 'location' In sheet 2, i also have column called "code", and 2 other columns for 'color' and 'size' the dream is, when userโฆ
-
Im trying to understand if there is a way to dictate what options are presented in a column drop dow
-
creating a pie chart of yes/no responses
Hi there, I have a smartsheet where 1 column is a yes/no column. I am trying to create a Dashboard with a pie chart that breaks down the percentage of yes responses and the percentage of no responses. I need some serious help, as I am getting a lot of error messages and cannot figure out where to even start.
-
Formula woes
Fairly new to Smartsheet and I can't get my formula to work, this is what I am trying do: If Due Date in Children row is less than today and Status is Not Started "Red", In Progress "Yellow", Done and in Review "Blue", Complete and Closed "Green". Thank you in advance!
-
20,000 Cell Links
I received an error window in Smartsheets stating that I cannot add more than 20,000 cell links on a sheet. However, the Warning message on this help page (link below) says that I can use more than 20,000 links, but I will not see more than 20,000 indicators.