-
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…
-
Why are most of my months showing up "N/A" when I know there is data?
Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below Populates only one month:
-
Help using the NOT formula
Hello! I'm trying to write a summary formula to count how many projects have a Resourcing score of 8 or higher and the approval status is not "canceled." This is the current formula I'm attempting: =COUNTIF([PM Resourcing Score]:[PM Resourcing Score], >=8, AND(NOT(CONTAINS("Canceled by Specialist Team", [Approval…
