-
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…
-
Status corresponding to % Complete
I would like to figure a way for the Status Column to auto fill depending on what the % Complete says. For instance: 0% = Not Started 1-99% In Progress 100% - Complete Conditional Formatting is not the way to go and I can't figure out the right If/Then statement to use. New to this world so don't think down on me too much.
-
Is there a way to return the row location of all instances of a duplicate value within a column?
I've created a duplicate flag column using the following formula: =COUNTIF(Email1, Email1) + " of " + COUNTIF(Email:Email, Email1). This shows the instance and the count. What I would like to be able to do is provide the row numbers of the duplicate emails. Match will only find the firs duplicate but won't return all of…
-
Consecutive Count of Children
Please help. This seems like it should be a fairly simple answer, but I’ve worked on this for hours with no success. I would like a count formula that counts the Children, and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This simple formula,…
