Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Discussion List
Setup webform data to overwrite existing cells above?
Is there a way to setup a webform that would collect numeric data for dropdown field parameter, and then have the output from the form automatically create or replace an existing numeric data in a cell above? Said another way, I am trying to see if I can create a webform can somehow mimic the functionality of the "Send…
Cell Link from web form
Hi, I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being posted below the cell which is linked to other sheet. I used the workout of providing the cell background color to white to…
Formulas Lost with Data Connector
I have used the data connector tool to export information from Smartsheet into Excel. While the information comes over correctly, all of my formulas get wiped out when I refresh the data. Is there a fix for this? Any help is greatly appreciated. Thank you.
Simple email capability?
is there any way to load an email address into a smartsheet cell and then send an email to that address simply by clicking on it?
Conditional Formatting Key or Legend
We use conditional formatting for our master training calendar to show which training is for which audience. I have been asked to provide a "key" that shows what each of the colors represents on the calendar, but I haven't been able to find an easy way to do this. Any ideas are welcome and appreciated!
Web Forms
Is there a way to change the font and colors of a web form?
How to run a project report without Sights?
Sights seem to be prohibitively expensive for a small team or small enterprise. I am trying to do my best to get by without them, which is very frustrating because not having a dashboard is pretty bad...so bad I think I won't renew going forward since competitors do a better job in my opinion. That said, has anyone found a…
Yesterday's Completed Task Formula
I am looking for a way to capture the number of taks that were completed yesterday. I started by using a report however yesterday or last working day were not an option. I tried using in the last days - and used 1 however when yesterday is a weekend is skews the data. I then tried using a COUNTIFS formula but I run into…
Folders in attachments
I have a client who wants to use Smartsheet as a central repository for all data pertaining to a tech kit install. My Client requires folder hierarchy in attachments on a row. They require this to have better visibility of attached files on a row. Each row is to have a details of a piece of tech kit installed with a…
Self-populating formulas in rows
Why don't the formulas instantly populate the next row? This is extremely frustrating. Sometimes, the self-population or smart population of formulas will occur in proceeding rows, and the other times, it won't. Is there some sort of trick or process to make sure this happens every time? Thanks in advance for any help with…