-
Help with making this work.
At the moment I am getting an error when trying to use this function. What can I do for it? =SUMIFS([Hours Left]@row, [Assigned To]@row, "Person's Name", [Due Date]@row, ">="&DATE(2023,8,1), [Due Date]@row, "<="&DATE(2023,8,31)
-
Help with formula
I am wanting to count the number of drop down items selected in a cell, but I only want it to count in the cell for a specific row. This is the sheet that i want to count the number of dropdown items from. This is the sheet that i want the formula written in to return an output. Currently I have =IF(HAS({centers},…
-
Formula to Change Symbols in Column Depending on Review Status
Hi all! I'm working on adding a formula to a column to populate status symbols in another column. I've attached an image of the sheet for clarity - I would like to display the symbols in the 'Director Approval Status' column, with the original dropdown selections listed in the 'Director Approval' column. Here is the…
-
Showing what quarters students are here from date ranges
Hello - I am trying to build a report for my supervisor that shows what quarters students are here from two date ranges. My columns are Experience Start Date Experience End date Quarter - I have this formula in quarter currently that pulls the quarter from whatever month the experience start date begins in ="Q" +…
-
Index Collect Formula for Dates resulting in Invalid Value Error
Good afternoon, I am trying to use an Index Collect formula to collect dates that have dependencies. Here is the formula I'm using: =INDEX(COLLECT({Portfolio Summary | Actual Start}, {Portfolio Summary | Project Number}, [Project Number]@row), 1) + "" I can confirm that the formula cell is a date column, as well as the…
-
How do I fix this error #INCORRECT ARGUMENT SET
=IF([Land Owner/Tenant]@row = "Owner", IF(OR([Replacement Closing Date]@row <> "", [Replacement Eligible?]@row = "No"), "", IF(OR([Buyout Closing Date]@row <> "", [Vacancy Inspection Date]@row <> ""), MIN(IF([Buyout Closing Date]@row = "", 99999999999999, [Buyout Closing Date]@row), IF([Vacancy Inspection Date]@row = "",…
-
#incorrect Argument set
I am trying to write an index formula and I keep getting #incorrect argument set. I am trying to reference data on one sheet and return the information from another sheet.
-
Need help calculating estimated completion date for production while excluding weekends
Hello Smartsheet Community! I have a project I am working on for work, and I am struggling with a formula to calculate the expected date of completion for our production orders based on a few criteria. A few things are missing that are confidential, but I have attached a picture of a practice spreadsheet: Please note: a…
-
Using Formula to List Data from Multiple Ancestor Columns
So I use Smartsheet for scheduling as well as job management. I am trying to have data from a parent row populate into a separate column on the child row. That is all listed parent Task Descriptions and the parent Job Description. My current formula is =JOIN(COLLECT(ANCESTORS([Job Description]@row), ANCESTORS([Task…
-
Calculating Values
New to Smartsheet here. Background on what I am trying to do. I would like to count the specific words that were selected from a multi check box and then multiply the count with the $ amount associated with that text. Example: User selects: Apple, Banana, Orange, these (3) selected options then get displayed together in…
