-
Formula using project plan Baseline columns that may not yet exist as Baseline hasn't been set
I would like to put a formula in place for the health of milestones within project plans deployed as templates in a Control Center blueprint. The formula would work similarly to how it works in the Project Plan template provided in the Project Management Office template set available in Smartsheet. However, the template…
-
Index Collect Has with a multi select reference column
I am working on a formula that will reference a column in Sheet A that may have multiple choices selected, and compare it to a column in Sheet B that will match one of the selections in Sheet A and return the word 'Completed' I've tried these 2 formulas and both return #INCORRECT ARGUMENT =INDEX(COLLECT({Equipment…
-
Unparsable Error for formula
I need to sum data in one column based on the month and year. =SUMIFS({011-AP Archive Computed Count}, {011-AP Archive Month}, 12, {011-AP Archive Year},2025)) I did the same formula for COUNTIFS, and it worked beautifully. =COUNTIFS({011-AP Archive Month}, 12, {011-AP Archive Year}, (2025)) Any help will be appreciated.
-
Moved: Automation Settings
This discussion has been moved.
-
Metric chart - Pie chart - % update
Hi, has something changed with the % update for Metric pie charts on dashboards, as before it was providing an option of rounding the % now its changed all my dashboard to 6.6 % etc, and the button at top has gone where I can update it to round the % off rather than actual as shown below?
-
How do I automate a cross check between two Employee Name columns that are formatted differently?
I've inherited a large set of sheets that were set up to pull in employee info based on an employee ID number input via form. There is an INDEX:MATCH to display the employee's name, supervisor, position, etc. from an agency roster based on the ID number. Because some employees mistype their ID number, the wrong info (or…
-
Counting Rows in a date range
I've been trying to just create a formal in my sheet summary to show a count of issues i have on a sheet (number of rows) between a date range, so how many issues were raised in 2024, I've got a Row ID column with auto numbering which i'm trying to draw on but i keep getting error messages? I feel like it's a simple count…
-
Add a date to a specific status change, but in the past
I would like to add the date when the status is changed to "Complete". I know I can do this with a formula or in automations. I am wondering if there is a way to back date it? So if it was marked complete before I create these formulas/automations will it pull the date from the past or will it pull the date I build.
-
I am receiving the error message #NO MATCH.
I am receiving the error message #NO MATCH after several attempts to troubleshoot the problem. I am wondering if the formula is broken? Current formula is: =IF([Individual Responsible]@row="","Machine/System",((VLOOKUP([Individual Responsible]@row,{Pop Report - Range},11,false))))
-
How to change column value whose property is Contact list before it is copied to another sheet
Hi, I have this 2 sheets where if a row is added it is copied into another sheet. What I want is before the copying, there is one column which i want to have a contact and then copy to another sheet. I have tried doing it using Automation, but changing a cell value is last step which can take place in automation, this is…