-
Sumifs formula shows wrong value
Hi., I have two sheets: one is the Master Sheet, where multiple people enter and update their status, and the other is a Report Sheet, which summarizes the data using a SUMIFS formula. I’ve been using this setup and formula for about two years without any issues. However, for the past two days, the summary sheet has been…
-
Project Intake management
There could be a very basic and simple answer to this, or a complicated one-I hope its simple!😀 We have around 50-100 projects at any given time and we need to track and report on various deliverables. I have set up Intake Form- Intake sheet-Portfolio tracker, as well as project plan for each project. The Intake form is…
-
When Smartsheet is down
Hey all! Just coming to the community board to see what options are out there or what others have done. I know today we have experienced a downtime with Smartsheet. Has anyone come up with a downtime procedure for times like this when it's down for longer than an hour? I am just trying to see what options are out there. I…
-
Is it possible to have SmartSheet do a celebratory confetti pop every time we hit "complete?"
Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Is it possible? Am I dreaming too big?
-
Broken formula - linking cells from one SS to another - help!
Hi. Someone on my team mistakenly broke a formula that linked a column called "Construction End Date" between 2 SSs. Source sheet name: De Novo SS Pipeline Source sheet column name: Construction End Date When a Construction End Date is typed in here, it should auto-populate a sheet named De Novo (New Builds). Target column…
-
Make Rows From "Active Projects" Sheet Transfer to Another Sheet ("Invoicing") Upon Job Completion
My company uses Smartsheet on an extremely rudimentary level. We are not tech savvy; we are tragically behind. We have only figured out to use one automation so far, which is when a new cabinet-related "project" gets automatically added to our "Active Projects" sheet from our "Sales Pipeline" sheet. But we have a major…
-
Cant log into Smartsheet after I changed a User from Member to Viewer
I am the System Admin for Smartsheet and a long time user. I changed some users from a Member license to viewer and now they are not able to log in to Smartsheet. I have submitted a case and am waiting for a response from support. Short of creating a new login with a different email address, how can I best resolve this…
-
Need help with IF statement that will return
I am new with Smartsheet but am tasked with creating a formula that will return a sum under certain conditions. If the Cost UoM is EACH I need to just return the value in Cost Per Unit, If not EACH then I need to return Nom. Output Cap. * Cost Per Unit. Thanks in advice everyone.
-
Copying Cells to Microsoft Word, PPT, Loop, etc
Hi there, I am attempting to use Smartsheet for meeting agenda planning. I have a sheet to house the meeting agendas and would like to be able to copy/paste the cells with the agenda items and their details to microsoft products for sharing across teams. It seems the only way to copy text from smartsheet is to highlight…
-
Trying to create a new sheet in a Workspace is throwing an unexpected exception C# SDK
I am trying to create a new Sheet in a specific Workspace using the Smartsheet SDK for C# and I keep getting an unexpected exception The statement above compiles just fine. The Workspace ID (wkspID in the code) is correct. I can create the Sheet just fine locally but the sheet does not have an ID until it is created in…