-
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…
-
Unable to rename a Sheet
We have a Sheet that is part of our Workspace which we cannot rename. Each time we rename it, no matter the user or where we try to rename it, the name reverts to the original name "Copy of xyz" instead of "V2_xyz" after we refresh the page and does not show the updated name for any users. Is there a bug which causes this?…