-
Notification of new comment - not to assigned user
Hi, I am new to SS and trying to find my way around. One question I have is how to send notifications when comments are added. I can see that I can send notification when column changes and choose comments column. I can then select to send it to a contact in column, and choose assigned user. However, if someone comments on…
-
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
-
Multi-Row Approvals
I want to migrate an existing SharePoint InfoPath form to SmartSheet. The form is a Budget Request Form. * Staff can submit a budget request with arbitrary number of items (rows) * Via a workflow, each item is Approved or Denied. * Via a workflow, the entire Request is Approved, Partially Approved, or Denied. The thing…
-
Give Specific User Editing Access to a Locked Column
I am looking to give a specific user access to editing a locked column. The background: We have a list of projects that are NOT to be started until our finance director approves said project. As the project manger, I am owner of these sheets. To prevent other users from approving projects of their own will, I have locked…
-
Best Practice - Data Integrity - Forms
When your business starts to build lots of sheets (as we have) the issue of data integrity comes into play. That is if you have lots sheets with names, or activities you can now put them into one sheet and reference to them BUT whenever you build a form and want to restrict the user selection to the defaults in the drop…
-
column restriction / assign task to multiple users
Dear Team, Can we restrict column for users and can we assign task to multiple people from the sheet.
-
Countif formula... using crosssheet formula
I've tried both... they don't work they say unparseable... what am i missing I want to I am looking to add up all P1's that have a region of America Break Fix and a status that is not finished or cancelled, then count all the P1's in the priority column. =COUNTIF({CS Current Months WO status - Status}="Open",{CS Current…
-
sumif formula
=SUMIF(Date past due: Date past due,>TODAY(), Amount:Amount) #unparsable The amount is coming from a vlookup from another smartsheet The past due date is a formula with in the same sheet
-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
Automatically add emails into smartsheet
Is it possible for an email to automatically be added into a smartsheet? Just like a form entry gets added, can someone send an email to a particular email address that is automatically added to a smartsheet? I saw an old post about this from a few years ago but want to know if this is something that can be done now. It…
