-
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…
-
iframe compatibility mode
Anyone got ideas on getting the published read-only iframes to work in IE's Compatibility mode? Using IE10 for an intranet site, but the Smartsheet in the iframe just continuously reloads
-
Earned Value Management
Please how do you calculate earned value with smartsheet? I have been looking at the videos but yet to find an answer.
-
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.
-
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…
-
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…
-
BUG - Alerts not Alerting
Hello Smartsheet, 3 months ago I used smartsheet to manage issues found during testing, Last week I used the exact same smartsheet to manage a new round of testing. This time there have been no Alerts sent....... It is as if the "Changes" option has just been deleted out of the alert. Dont know how this can be done, I…
-
Number of licenses?
I'm wondering how other folks are using Smartsheet. How do you decide who gets a license versus just emailing rows or publishing editable sheets to be updated from your team? How many licenses do you use for the size organization that you are?
-
Notifications - Changes to cell also notifies when cell is created
Currently I have a sheet that set set to receive data from a smartsheet form. That form puts the data at the top of my sheet. I have a checkbox that is checked by default in the form [column name: New Employee]. I also have an alert that says if column "New Employee" changes notify me right away. Now at this point I have…
-
Column headers not aligned
My column headers recently became misaligned. I have attached a screenshot. This is only happening on some of my sheets but not all. Any time that I create a new sheet this happens as well. I am working on a Mac and using Safari. Note: When I use Chrome on the same Mac, I do not experience this issue.
