-
Limit to Shares for Admin and Editors w/o Subscription
Hi Smartsheet Community, I do not have a paid subscription but was set up as an Admin for a sheet. I had only shared it with 2 people before it sent me a message that I had exceeded the number of email recipients that I could share with. Is this accurate? Do "editors" with sharing privileges have more shares that admin?…
-
Trigger To Move Row
Created workflow automation to move a row based on a single condition. After successful testing, edited the workflow to add a second "or when" condition. After saving, the workflow stopped working. The only workaround was to delete the workflow and recreate it; which worked.
-
Index/Match? Not sure best function for my needs
Hello, I have a very extensive sales tracker that I use to log charges and calculate the sales rep's commissions based on those charges. The commission percentages change depending on a variety of scenarios, so I created four columns with separate formulas for each scenario. I need the commission column to auto-populate…
-
Counting people with the same email domain in a multiselect assigned to cell
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of the contacts in the cell belong to the same company. I.e. have the same email domain. In…
-
Automatic report creation with custom template
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API or integration with any other platform that would make this possible? Any help is much…
-
ODBC data pulls US date to mail merge
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format (DD/MM/YY) to US format (YYYY-MM-DD) and the only way I can find to resolve this is…
-
Is there a way to deal with "maybe situations" or varying predecessors?
Hi SmartSheet community! This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but only on an as-needed basis dependent on results. For example, we anticipate product A will need 4…
-
How do you expand the height of a row?
How do you expand the height of a row?
-
HELP with a large sheet and table layout/conditional formatting
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 dates - planned date, reforecasted date and actual end date. I need a report that…
-
Which formula should I use if I want to add up all values from a column?
To give a little bit of context, I am creating a report where I can count whether a cell has been filled with information. The column I am using is a drop down list with 5 values. Let's say these values are apples, bananas, oranges, pears, etc. I am not looking for the total of each specific value, I want all of the values…