-
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…
-
Children from a different column
I'm working on a stock inventory program for my company. The Parent row is the Running total, min/max barcode, description and so on. The Children will be the stock coming in and going out. I can on the Parent row Sum Children in IN column an then Sum Children in OUT column them have the formula in Parent Stock cell…