-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
Hello all, I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({Total}, but when I add the criteria for each department I get # INCORRECT ARGUMENT SET.…
-
My simple NETWORKDAYS is not correct. I'm stumped. :(
Trying to figure out what I'm doing wrong here. I want to calculate the number of work days between two dates. My formula: =NETWORKDAY([Start Date1]5, [End Date1]5) It returns 62, but should be more like 86. What am I doing wrong here?
-
Set a default value in a pick list column
I have a column in a project tracking smartsheet that shows the status of a project. I would like the parent row for the project to automatically change depending on the status of the child rows. I can do that through the formula: =IF((COUNTIF(CHILDREN(), "Withdrawn") + (COUNTIF(CHILDREN(), "Requested"))) =…
-
2 pet peeves - Printing and Filters for columns
Not really a question. More of constructive criticism/asking for better developed features. I use Smartsheet as a scheduling tool at our company, We use master project sheets and a series of project reports and company reports. We generally use Gantt Charts so mostly these comments pertain to that view. For the most part,…
-
Shouldn't Multi-factor be standard?
I just wanted to get a sense from other business customers if they are looking for multi-factor to be a standard feature for all accounts? I'm curious why SmartSheet isn't trying to secure all their customers with common security technology? Thoughts?
-
Auto-status, 'Up Next' criteria overlap
Hello! I am working on a sheet with Start/Finish dates and need to populate status' into the following 4 categories: not started, in progress, complete, up next For not started/in progress/complete i have the following formula working: =IF(AND([Start Date]@row < TODAY(), [Finish Date]@row < TODAY()), "Complete", IF([Start…
-
I need help with a formula, I need it to return a blank cell.
I have the following 2 formulas: =IF([Rental Period]3 = "Daily", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 2, false), IF([Rental Period]3 = "Weekly", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 3, false), IF([Rental Period]3 = "Monthly", VLOOKUP([Scissor Lifts]3, {Scissor Rates 2}, 4, false), ""))) =IF([Rental Period]1…
-
Countifs #INCORRECT ARGUMENT SET
Hello, I'm trying to get the following countifs function to work but I'm getting the Incorrect Argument Set error: =COUNTIFS([Employee Name]:[Employee Name], "Name", Sunday:Saturday, "W") For context I'm trying to count the number of days specific employees have worked YTD.
-
COUNTIFS and SUMIFS with a Date Range
Hello, I'm trying to count the number of cells that have a date in the year 2020. This is the formula that is returning "0" which is incorrect: =COUNTIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], >=DATE(2020, 1, 1)) Additionally, I want to sum the values that correspond to this date range, and…
-
Sender of Workflow emails
Hello, we are currently working on an solution where we need to collect input from users outside our organization. While the workflow works fine, emails appear as send from "automation@smartsheet.com". To make it more likely for users to respond to our request, we would prefer it being send from one of our company…