-
Formulas to calculate data received from web form
This is a screenshot of my page that I want to try and get the formulars for. The cells that are in yellow, the data in those cells will come from my staff that I have complete the web form that i have attached to this sheet. The red cells are the ones that I require the formulas for to calculate the different times that I…
-
Dashboard Add-On Change
As new Smartsheet users we were excited to start implementing Smartsheet and had plans to use the Dashboard. It is disappointing to learn without warning that the Dashboard has been removed and will be an expensive add-on for Team licenses. Was anyone else aware this was happening? Will you just plan to get by without the…
-
include TIME in the column properties
Hi Smartsheet, Is it possible for you to add Time column property?
-
Automate Value Recording
All, I am trying to setup a PMO dashboard where I am putting Total Portfolio Value graph. I have to update the graph fortnightly to record current value. Is there anyway to automate this function so that everytime I dont have to manually enter value.
-
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
