-
#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…
-
Is there a way to move a dependant date further out without using lag?
I have a background of using MS Project where 'predecessors' are the equivalent of 'dependencies'. I have got used to smartsheets pretty quickly and for the most part get along with it but feel that there is a definite limitation when using dependencies as follows: In MS project if I have line 1 completing 28/11/23, I can…
-
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…
-
Allow bulk deletion of projects in Control Center
Allow users to delete multiple projects in Control Center at the same time. Currently, we can only delete one project at a time. We have passed the recommended limit of 5,000 active and archived projects on a program and would like to delete some projects. The only delete option for active and/or archived projects is one…
-
Proposal Project Creation
We are slowly implementing Smartsheet from Trello and have a few questions on how to automate this to make it easier. We use a Form for our Coordinators to fill out information (RFP Name, due date, exceptions due...) so that this can be added automatically to a master list of RFPs for the year. With this, is it possible,…
-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…
-
Creation Date Report
Hi All, I'm looking to create a report that will allow me to source the creation date of all my sheets. I've tried googling but all reports lead me to last edit dates rather than the original sheet creation date. Any assistance would be greatly appreciated. Thanks, Evan.
-
COUNTIF Formula for Multiple Statues and Conditions
Hi, I'm struggling to have a working formula that would meet the conditions I am trying to have shown. The 6 statuses are: Not Started, In Progress, Completed, Cancelled, On Hold, Delayed So here's the logic I'm trying to apply: If all children are Not Started, the parent is Not Started If all children are In Progress, the…
-
Status Change Formula Unparseable
My sheet requests dates at certain milestones which should change a status from 1-10. My formula is not working and I think it is likely a syntax problem. Can someone assist please? =IF([10. Date of Closeout (Kayla)]@row,"10",IF([9. Date Invoice Received (PM)]@row,"9",IF([8. Date RR is Received (PM)]@row,"8",IF([7.…
-
Duration as a formula to accommodate resource allocation varience
I have three columns in my schedule sheet. Duration (native column) hours and resource allocation. I would like the Duration to be my hours divided by my resource allocation. So If I plan to put 2 people on a 80 hours project my duration is only 5 days not 10. I tried a formula in my duration column but it doesn't allow…
