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
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!
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…
Checking checklists
Hi all, I have a series of columns with checklists that I need to analyse and need some help, please. The logic is this: if the report is "completed", but _any_ of the several asset check cells are still not checked, a cell called "asset checks not complete" should fire up. The formula I have is below, but the "asset check…
Links in Templates?
How do you make a link in a template? I am designing a system that uses a to-do list for each new transaction - the blank to-do list is stored as a template. There are three columns on the template. 1. The item to do 2. The status control (done / not done) 3. Links back to another sheet with detailed information about how…
Report on today and next workday
I'd like a Report that shows rows with the Date field from today or the next workday. That is on Monday - shows Monday/Tuesday Tuesday - shows Tuesday/Wednesday ... Friday - shows Friday/Monday Saturday - shows Saturday/Monday Sunday - shows Sunday/Monday My sheet is very complictated and starting to visibly slow down so…
Entering Address Information
One of our users has a sheet that includes an Address field to store mailing address information. They have created this as a Text/Number field an enter multiple lines of data (c/o, address line 1, address, line 2, city/state/zip). The same Address information applies to mutliple rows of data, but currently they need to…
Formula help - set values for current user and date when check box checked
I have a checklist I am building for a department where they will be primarily mobile users so I would like to reduce the thumb typing as much as possible. I see where I can use test the value of a checkbox and make it do things.. but what I want to do is get the current date and current user. So that when someone clicks…
Ability to use differnt font colors in a cell
Would anyone else find it useful to be able to use use different font color for certain words in a cell only, rather than having to change the font color of the entire cell? The ability might also be nice to be able to underline and italicize certain words in a cell as well but definitely colored font to call out…
how do i shut off the "Try Card View - NEW!" popup??
Everytime I click a new tab, this notification pops up. I click "go it" and it still pops up. How can I shut this off?
IF THIS AND THIS then TRUE CHECKBOX
Since Smartsheets currently doesn't have timestamping system I am using manual dates to do so however I need a checkbox to be ticked to alert me when two conditions have been met. These conditions are dates and are blank before data goes into them. What I thought would work is =IF(AND([Date1]1 > 0, [Date2]1 > 0), TRUE )…
