-
Sheet Summary Formula to count text cells that are not blank
Hello, I am having a hard time setting up this formula in Sheet Summary =COUNTIF([Core Customer Name]:[Core Customer Name], "ISNOTBLANK" Can someone help?
-
Core Product Certification Renewal - Report PDUs
Hello, I completed 12 PDUs to renew my core product certification, but I don't see anywhere that I can report the PDUs, or formally renew this certificate. In looking at my profile, it doesn't show that the certification expires (below), but I know it has to be renewed each year, I just don't know how. Does it…
-
Making a training registry
So i am attempting to create a sheet where an employee would fill out a form and check into the training. This will go onto a sheet called "Hicksville Training Sign In" They fill out the form and it populates the rows. Then I want the form to match two variables into the sheet called "EE Matrix" I want it to Match a column…
-
Formulas using another sheet references
Hi, I have a created a sheet (Financial Dashborad sheet), to calculate the total finances spent by each subdepartment, and the running costs for each subdepartment. The data was present in a master financial sheet, holding all the information. I am looking to create a dashboard via populating a sheet (Financial Dashboard…
-
Linking multiple schedules together from different sheets
Hello, we need to link different schedules together from different sheets. So at a certain date on schedule 1 the schedule 2 will start. If anything is delayed on schedule 1 it will auto update schedule 2…how do we do this? Thank you!
-
Copy row automation is not copying all data (assigned people in contact list row)
We have a 'copy rows to another sheet' automation that is working correctly except for one column, the "assigned to"/contacts column has stopped copying the data. It was working well until last week. No changes to the automation took place. I removed and re-added the automation and confirmed no automations in the…
-
Unable to display the Graph Bar for my Second Series
I have two set of data ranges, Column 1, shows the Total Number of Shipments and Column 2 shows Total $ Amount per shipment. I want Smartsheet to show bars for each of the two columns but currently I'm only seeing a bar for Column 2 Total $ Amount per shipment and only the number Qty for column 1 , Any help or suggestion…
-
Report is pulling identical columns
I am creating a report that is pulling from 30 sheets. The sheets all have a "Project Manager" column, and 1 of the 30 sheets is pulling the "Project Manager" column as a separate column than the others. The columns appear to be identical on the 29 sheets vs 1 sheet. How can I have the columns populate the project manager…
-
Is there a way to set up repeating notifications until status changes?
I work in a Lab and have set up an Incident form so we can track and record each incident through to completion/solution. Right now, it's set to ping a person when an incident is added to the list but beyond that, it waits for a manual change to the form when someone goes in and addresses it. I need to know if there is a…
-
Invalid Workflow Error
Hi all, I just received an email saying a workflow has become invalid because it contains automated actions that are only available to Business or Enterprise plans, but we're currently on a Business plan, so I'm not sure why this message triggered in the first place. Thankfully I was able to reactivate the workflow and run…
