-
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?…
-
Duplicate Workflow Condition Paths Option
Currently when building a workflow, if you need to create more than one condition path but only 1 or two criteria out of several are different in each condition path, you have to recreate each condition path from scratch. This can get very time consuming if you need multiple condition paths. Could a function be added on…
-
View only
Can someone with View only premission on a sheet, save a copy of the sheet or export it?
-
Smartsheet Outlook plugin/add on
Hi, one of our users is trying to use Smartsheet for Outlook plugin/add on and is always asking for Admin approval to use it. How do I grant consent for my users to use the Smartsheet for Outlook plugin. We are using M365 email service.