-
Sending email via gmail from Smartsheet
I use Smartsheet to remind myself when to send various emails to different contacts. I would like to be able to set up a list of contacts for each sheet complete with email addresses (and phone numbers) and be able to click on the email address and have it take me to my Gmail account where I have multiple canned emails…
-
address formula
What would be the formula to separate the address into plus for separation. I have tried a few different ways and haven't had sucsess.
-
I have two templates with links to each other and need help
I have created two sheets for our company travel planning, one is a budget planning sheet, and one is a trip strategy sheet. There are hyperlinks to jump between the sheets, and cell links to transfer data from sheet to sheet. When I make the daughter sheets, I would link the links to automatically update, right now I have…
-
Calculate with row numbers / Formulas not copied after adding new rows
Every now and then I notice that formulas are not copied when a new row is added to a sheet. Very often these formulas are placed in hidden columns and so it's not immediately obvious. So, I'm looking for a way to get an "alert" in a cell within Smartsheet whenever a cell in a specific range is empty, showing the amount of…
-
Sight - Report Widget
Hi All, I have a report with list of names in one of the column, I have linked the names to their respective sheets, the link shows in the report and works fine but when I pull this report in Sight thru Report Widget, link disappears. Edit Interaction in Configure Report Widget can link to only a single sheet , multiple…
-
is smartsheet down?
I unable to enter the application, it keeps saying "smartsheet is loading ..." The problem started for me about an hour ago.
-
Is there a way to build a template containing multiple sheets
What I'm trying to do (maybe there is a better way) is to build a project template with contains the project sheet, a requirements sheet, and a budget sheet. When we "use" the template, it then creates all three sheets. Similar to the "Solutions" on the Smartsheet website. Thanks in advance for any help.
-
help - with formula/cell linking across multiple sheets automatically, without having to manually ad
Summary: I have loads of sheets in a "project" folder, 1 for each project, which have identical layout (column names etc). Each sheets has a region field, which is either UK, China, Japan, HK or Multi. I then have reports which take the relevant information I need from all sheets in the "report" folder, which is then…
-
Feature Request - Pattern Overlay on Gantt bars
It'd be handy to be able to add a pattern overlay to Gantt bars. Like these: http://www.webdesigndev.com/wp-content/uploads/2015/02/20-Repeatable-Pixel-Patterns.jpg The use case for us is that we want to color code our bars for who the'yre assigned to, but be able to label some of those bars as having a "fuzzy" deliverable…
-
how to sum the column amounts, if the status of each raw is Green and that is before end of may
trying to establish a quick summary report for Senior Management. want to sum the amounts in the contracts column, if the status of raw items are green and the date is happening before end of may. highly appreciate your guidance.
