-
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 )…
