-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…
-
Formulas not updating when new data is added to underlying sheet
When new data is added or updated to the underlying sheet, the formulas are not recalculating. I run an upload workflow each morning and want the metrics sheet below to recalculate based on the updated report I attach. I have to manually re-enter the formula to get an updated metric. The counts, averages and formulas using…
-
Is there a way to set a constraint on a task's Start Date that can override a predecessor?
We have migrated a fairly complex plan from MS Project to Smartsheet and have been able to line up most of our dates. However, when Predecessors finish early on a task, the start date is impacted, as expected. In MS Project we can use constraints to say the next task cannot start early even if its predecessors end early.…
-
Trigger a monthly approval automation?
Hi there, A team keep track of hours worked per project on a sheet that looks like this. I'd like to trigger a workflow that sends the project manager an approval request on the first date of each month to approve the work completed the month prior. However, I do not want the project manager to get separate emails for each…
-
Add Latest Comment Column without creating a comment
When creating a Grid, need the ability to add Latest Comment in Grid view without having to add a comment first. Thank you.
-
Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells instead…
-
Pivot Table Like UI For Creating Metrics in Sheet Summaries
In Excel you can customize formulas and drag and drop the information you want int Rows, Columns, Filters, etc... via Pivot Tables to build data points and summaries of large amonts of data. If we could bring this functionality to Smartsheet's Sheet Summary with the help of the recent LLM functionalities implemented for…
-
Merged: Organising Structure For Automations
This discussion has been merged.
-
Alert/Notification when line item hasn't been added
I am building a sheet in which 6 managers provide updates in the form of line items. Each week our Director reviews this sheet for the latest updates. I am looking to create a notification system that would go out to each manager that doesn't provide at least one update (add one line or modify an existing line) in the last…
-
Is there a way to delete a cross sheet reference?
I had a working formula referencing another sheet. It was referencing a set of cells in a column. I changed it to look at the entire column and started getting an #Incorrect Argument Set message. I tried to change it back to the range of cells and I'm still getting the error message. I wanted to delete the cross sheet…