-
Pushing data from Smartsheet to 10000ft
Hello, i am trying to set up a project request form which requires authorisation and once this is recieved it pushes fields through to 10000ft as a new project. I can see how to send info through to Slack and MS Teams, but not 10000ft. Can anybody help? Thanks
-
Join Collect Function not working
Hello! I have this formula and it doesn't seem to work: =JOIN(COLLECT([Capacity-Space Planning]2:[Capacity-Space Planning]245, [Property Name]2:[Property Name]245, [Property Name]@row, Space2:Space245, Space@row)) I'm not sure what I'm doing wring, it's not bring back anything. Help!
-
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.