-
IF FORMULA
Hello there! I'm new to Smartsheet and I haven't found an answer to my question yet. I would like to make a symbol appear if a set of cells are not empty. In a few words, if cell A, B, C are not empty then I will have a green ball on cell D. Is it possible? How? Thank you :)
-
Grammar/Spell Check Request
Can I request for spell check? This hasn't been an issue (or at least not raised) and I would like to keep it that way. The Chrome browser option isn't so user-friendly; no 1-click scan or doesn't automatically show misspelled words.
-
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…
-
Love the "Freeze" pane option!
We just started using this option, as we have 71 columns in a particular sheet and scrolling back and forth was becoming quite cumbersome and inefficient. We put our three most important columns at the front of the sheet and the the freeze pane in place at the end of the third column. So far it's been noted as a very good…
-
If Statement & Dropdown List
I have a dropdown list with 5 values and inserted an IF statement into the cells for that column to auto-fill 1 of the 5 values. I noticed when doing this you can no longer access the drop down list. Is there a way to auto-fill so the cell isn't blank to start but still allow users to access the 5 values in the list?
-
Date Formulas
I need to keep track of the day an item is approved. Is there a formula that I can use to generate a date that a check box is checked off?? Tiare
-
Setting an alert of Green Status
Hello everyone, I am very new to SS and would like your help on the following topic: When the Status goes to Green (only on green) to send an e-mail to a specific person. All that I am getting is everytime I change status to any color will send the e-mail. Thank you
-
Filter Resource View
Resource Views are handy to work with however as I try to balance/level our resources it would be a lot easier to have a way to automatically filter a user resopurce view to only show over-allocated resources. Currently have to run for all resources then just look at ones with red heads icon in allocatrion column. While…
-
Create percentage complete based of boxes checked
Hello, I am very new to smartsheet and still quite inept. I have a smartsheet that I am using to track a student I am mentoring. There is a coumn titled 'Completed'. This allows the student to check when a specific task is complete. I want to be able to show the percentage complete based off how many boxes are checked as…
-
PLANNED VERSUS ACTUAL PROGRESS
hi, is there a way that i can see the planned versus actual progress of the project ? baseline versus actual? thanks.
