-
Conditional Formatting - Using Current Date to apply formatting rule
I'd like to use the Today() instead of a hard coded date (i.e. 03/23/22) so it changes each day when using conditional formatting. Does anyone know if there is a way to do this?
-
Is there an escape character for column names?
I have a sheet that was created through a .csv import. One of the column names ends with "(RA", probably because of character limits. However, this is creating a problem with formulas. When writing an IF statement, the open parenthesis was treated as part of the formula, rather than part of the column name, despite being…
-
Preserve sort criteria?
I sort my sheet by three criteria. If I enter those criteria, sort the sheet, and then go to sort it again, the criteria are reset to the default (just one criteria on the primary column is populated). Is there a flag to preserve the sort criteria for all users so we're all sorting by the same criteria by default?
-
Getting value of cell in another sheet based on multiple criteria using OR
I have a sheet (Data Updates) that is a log of updates to all of our databases, including future updates. The log includes the Product, the Updated Through Date, a Start Date [to start the update], an End Date [update should be completed by this date], and a Status (options: Next Up [this is the Updated Through date that…
-
Help with team-vacation-planner template
I'm using the Team Vacation Planner template located at: https://www.smartsheet.com/marketplace/us/templates/team-vacation-planner It's a great template, but I can' work out how to add additional team members and retain the formulas structure. In particular, how would I: 1 - Create new staff and for them to appear on the…
-
NETWORKDAYS definable at row level??
I'm using the useful template located at: https://www.smartsheet.com/marketplace/us/templates/team-vacation-planner The only issue I have is that NETWORKDAYS are defined at a global level it seems in Smartsheet settings, which by default are excluding Saturdays and Sundays, which is perfect for my full time staff. However,…
-
Two Dates fx
Hello what formula would be best show one date from two columns? For example we submit for permit on date 1 and then receive the permit on date 2. What I would like to do is have one smartsheet that shows only one of those dates. So if there is a date for permit submission and not for permit received the cell would show…
-
Help with COUNTIFS Formula
Hi everyone! I am hoping someone could please help me. I need a formula that will count the number of times an action is complete (shown in the formula as CY22 Post Selection Support Inventory Range 9), and by a specific person who completed the action (shown in the formula as CY22 Post Selection Support Inventory Range…
-
Trying to count a flagged item
=COUNTIFS({MASTER - Daily Report - Employee}, [Employee Name]@row, {MASTER - Daily Report - Date}, @cell >= [Start Date]@row, {MASTER - Daily Report - Date}, @cell <= [End Date]@row, {MASTER - Daily Report - Late}, 1) Can you help with this formula? Im getting #Incorrect Argument
-
Formula: if checkbox is checked then add or subtract
Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse. The idea is that employees report via a dashboard whether they are taking something out of stock or returning something. If one checks the column "IN" or "OUT" they also have to add the amount. That amount should be…