-
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.
-
Cell linking
Hi, I was wondering if it is possible to link my sheet to another sheet that will automatically generate new entries. I have a master log in Smartsheet that i use for all the background check information that only an internal team has access too. When i filter though for a certain company in that sheet I would like to be…
-
Does 365 / One Drive help the attachment process within Smartsheet?
Hi, Our Company has just installed Office 365 to all laptops. We did this for various reason: 1. We didn't want anyone saving work to their C drive and losing it if a virus struck (so everything that isn't saved to Smartsheet is saved to One Drive. 2. We wanted to ensure that all documents can be accessed from any laptop/…
-
How do I automate and validate data from one column to another
For example, have a list of cost centres in one column using a drop down list, now I want the managers name for that cost centre to populate in next column. In excel i would just use a lookup or match/index to validate and populate. Cannot work out how to do it in smartsheet.
-
Date/time stamp format on PDF export
Hi is it possible to/how can I change the format of the date/time stamp included when export to PDF? I'm not sure where it is coming from, but it would be very nice to drop the "o'clock WEST' wording that is being included by default (see attached screen shot). I am using Safari v9.1.1 on Mac OS 10.11.5 Thank you Erik