-
Conditional Formatting and Checkboxes
Is there a way to set conditional formatting on a checkbox column so that if text is entered in one column, the checkbox in another column is automatically checked?
-
Smaller URL
I have a form with a long URL that i would like to make into a smaller user friendly URL that i can send out. I've use tinyurl.com in the past but i was hoping that Smartsheet could do it. Does anyone know if this is possible and how I'd go about it? Thank you,
-
Can't add jpg as attachment, doc and pdfs work fine
It's rather odd. We can't upload jpg from our location however, our external contractors were able to upload the exact file. We are able to upload pdf or doc(x). I note that there was a similar situation in 2017 but that was attributed to AWS S3 services. Is anyone else experiencing similar issues?
-
match in grandchildren
Hello all, I have a problem to which I can't find a solution. I hope you will be able to solve it.We have a store page where we collect data from parts from different departments. We then assign those parts to a project using a parent/child relationship. On the parent line, we use formulas like this one:…
-
Invalid recipients of notifications removed from SmartSheet sharing access
I'm using alerts/notifications and getting false positive alerts about invalid recipients who happen to be on vacation with automated out-of-office replies. I get an alert as shown below with steps to change permissions for including the inactive users in the automated notifications that were originally set up. The funny…
-
Help With Dates If Certain Criteria are met
Hi I am trying to work out how to Auto work out overdue date See attached i would like to get my Site Audit Complete column when marked "yes" to calculate the "Site Audit HN Dead Line" column's date continually move my overdue date to the current date each day until column marked Site "Audit approved" is marked Yes Is…
-
Harvey Balls not changing
Why aren't my balls changing color? Here is my formula =IF([% Complete]2 < 50, "Red", IF([% Complete]2 = 100, "Green", "Yellow")) I have been stuck on this for awhile Thanks, Ken
-
INDEX-MATCH Showing Wrong Information
I am using the following to pull a course title from another sheet: =IFERROR(INDEX({SubjectCourses-Titles-Credit}, MATCH([Subject + Course]31, {Subject+Course}), 3), "") It has worked fine with several course codes (Subject + Course), but when I enter an incorrect course code (i.e., it doesn't exist, such as HOS 419), it…
-
Status symbols that are color-blind friendly
Hello! I'm using the Red, Yellow, Green, and Gray status icons in a report that I present during my weekly manager meeting. Unfortunately, our CEO is color blind and has trouble seeing the colors. Would it be possible to add additional status icons such as these but with different shapes, such as circle, square, triangle,…
-
Lag between sheet structure update and Report Builder
I have seen this happen a few times .. I change the column names in a sheet and then go to build a report - the new column names are not shown in report builder. Sometimes it takes over 24 hours for the right column names to show up in report builder. See attached.. * Type field is shown twice in Report Builder * Task Name…
