-
Free User can't modify sheet
Hi All, I have shared a sheet with an unlicensed use with the role as "Editor - Can Share", but it can only access to the sheet in Only View mode and it cannot edit. What i'm doing wrong? Thank you in advance, BR --Dennys
-
MEDIAN() Column formula keeps breaking.
Hello Smart people, I have a solution that uses four sheets. The first, is an export of vehicle assignments from a vehicle management system. Data Shuttle overwrites all data in this sheet at 12:00AM each day. The second sheet (Daily Rental Summary), is a sheet to aggregate daily totals. A workflow adds a new row to this…
-
Do group admins have to be in a group?
Hey there, I have made groups that I want to continue to manage, but I do not want to be a member of the group. Smartsheet seems to add the group admin by default and when I delete myself from a group, I reappear. For example, I want to make and manage an HR group, but I am not in HR. However, since I am the group admin, I…
-
Automation Workflow Not Consistently Working
Hi! I set up an automation workflow on a form I created in Smartsheet. I have tested it twice; with one group it worked and each person received the email notification to approve or deny, however, the other group no email notifications were received to take action. I did not update the workflow between test groups and the…
-
Upgraded to Pro, now backup will not complete-wants us to upgrade to Pro...?
Hi. I've submitted a support request for this issue but it's now been returned, thanks but we're not available to help you (paraphrasing). So, I'm here to ask the community if anyone has seen this error and may be able to offer any suggestions. We had an individual plan and did manual backups each week. Upgraded to Pro…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Automated Workflows Not Triggering
I have a very simple automation - email trigger when status changed. I has worked for over a year but suddenly stopped. I have duplicated, edited and updated the workflow and no change. I did see mention of making sure your cells/rows were not at the maximum, but cannot find what that number is. We are over 1300…
-
Why can't charts widget select columns from sheets?
I'm setting up standard line graphs through using the charts widget on a dashboard. I am pulling the source data from sheets which get updated once a quarter with information I would like added to the report automatically. It seems that I can only select a data range and not select the entire columns so that the graphs…
-
At Risk Formula that utilizes end date and status columns only...
I am stumped. I have tried various formulas only for them to error. The closest I have come is the following but I am missing pieces. =IF([End Date]@row = "", 0, IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1)) BUT... I need it to do more: I need it to NOT USE % Complete I need it to flag at least 14 days prior…
-
Can I create a contact group of non-Smartsheet users for a distro list?
Hi, I'm looking to set up a contact group for an event sign-up sheet, but the audience is mostly non-Smartsheet account/license holders. I'm working on bulk uploading the list as a .csv file and developing the group now, but I'm wondering if everyone on the list will require a license to be able to access it and enter…
