-
Pulling cell data based on date and name
Hello, Could someone help me with a bit of a pickle I can't get around? I have a sheet with multiple dates and names and their daily progress. The dates are pre-populated for the entire month with everyone's names assigned for each day. I've been trying to figure out how I can extract the status percentage for a specific…
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Sequential numbering not working (Project with WBS sheet)
Hi All, I am fairly new to Smartsheets, so please be kind :) I am creating a WBS with the Template the Smartsheets provides (Project with WBS sheet), but I am noticing that when I add new tasks between other already created tasks, the numbering goes all wrong. Also, Even if I add more tasks underneath, the numbering is not…
-
Immediate Auto-Save
I'm trying to implement a solution for a team that needs changes automatically and immediately saved so the rest of the team can see the changes without delay. Is there a way to set each user's auto-save to immediate, rather than the current 1 minute? Or is there another suggestion for how to setup the sheet so that the…
-
Moving a project to another blueprint in Control Center
To setup Control Center Portfolio WorkApps, you have to start with a new blueprint. Short of having to re-spin up assets, it does not appear there is a way to transfer a project from one blueprint to another in Control Center. For Example - you have Blueprint x that pulls from Intake and outputs to Master Project List. To…
-
Issue with report not displaying all rows on Dashboard
I created a report based on a date, which itself is the result of a formula based on a number + an Assigned Date. The report displays a count of each row that has a particular date. The issue is that the dashboard will not display the first row with a count (see screenshots). When I re-sort the data to display the newest…
-
"Rows deleted" no longer a trigger option. How can I track deletions?
When setting up a workflow to alert someone, I no longer see the trigger option of "when rows are deleted". How can I receive notification of this action?
-
COUNTIF or SUMIF Formula in Report Summaries
Currently the summary count function only supports basic formulas. It would be great to be able to have the ability to use a COUNTIF or SUMIF Formula in report summaries. Specifically to count only the checked boxes. This feature would be nice to roll up metric data quickly and avoid the need to create a separate metric…
-
Parent Rows in Report
Hello, I have a made a current user report which shows only tasks where the current user needs to update. However I need the parent rows to show above the current user which may not be assigned to the same user. Is there any way to show parent rows in a report if there is filters that are applied which stop from parent…
-
Formula does not appear to be working
Okay, first, here is my formula: =IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1)) It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a…