-
IF(And formulas to count late dates
I would like to create a formula that measures the health of a project (Red, yellow, green) with missing dates: Expected Date (June 6, 2019)- I assign that date to the vendor Scheduled Date (this is expected within 5 days of assigned expected date)- this is filled in by vendor Completed Date (this is expected within 5 days…
-
How to write Nested IF statements each on separate line?
Hi, I have this nested IF statement that I would like to have each IF condition on a new line for easier reading and to follow coding best practices. Here is what I have now: =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow",…
-
Medical Publication Tracking- what is best template to start?
Hello, Any insight to the best Template or Template Sets to use to initiate: --basic tracking for medical publications (ie, manuscript development; congress abstracts & posters & presentations) --with "at risk" elements; or Red, Yellow, Green notifications Thanks!
-
Share a sheet with all users
At my company we have a few hundred users. They are all divided up into departmental groups also. Is there an easy way to share a sheet or workspace with all users at once. All I see in the list are all the departmental groups and the individual users. Nothing like an "Everyone" selection or something similar to that.…
-
High Contrast and low vision
Hey smartsheeters! I use smartsheet(s) everyday and I have a rare retina disease that makes the bright white screens hard to read, is there a way to invert the screen colors? A nice bland gray with black or white letters would be lovely. Most of the programs I use invert based on my PC settings, but not smartsheet. Let me…
-
Enhancement Request - Parents as Criteria in Reports
I would like to have parents be used as filtering criteria in reports without 1. Showing the parent row which is generally useless and 2. The need for a helper column. Yes this is easily solvable with a helper column and the Parent() formula, but this is an ugly solution that fills up the sheet with more columns and more…
-
access rights
I need to give access rights only to certain people to edit a particular column in a unfiltered worksheet, All the info in the worksheet needs to be visible to all the members. Can this be done?
-
Use data from a form field in the alert email title.
Setting up an alert system that sends out notifications when a form has been completed. To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emails with the same title. Is that possible and if so, how? Cheers
-
Help expediting Data Entry
Greetings, Looking to get some help speeding up our data entry process. We have a note that looks like this: Name: John Doe Phone: 555-555-5555 Email: email@mail.com-and about 15 more fields. These fields need to be taken from the note and manually input in our Smartsheet. I would like to know if it's possible to paste a…
-
Attaching google doc, pulls up the sheet's creator, not mine
I am using a single license Smartsheet application. When I want to attached a google doc and click on the paper clip icon to insert, it gives me the choices of different locations. When I select Google doc it brings me to someone else's google drive. It is like it is linked or preset. Where to I change that or reset it?…
