-
Gantt Chart Settings Not Applying
Hi! I am trying to create a dashboard that has multiple gantt charts. I want the gantt chart to display from the current date, which is already an existing setting. I've checked the box on both my workspace, and the reports I am using on my dashboard, and for some reason the current date does not display. Has anyone run…
-
New sheets created in one browser tab not available in other browser tabs.
When I create a new sheet in a different browser tab - you know, because we can't open multiple tabs anymore - the sheet is not available in the other tabs. I went out of the folder and back in to give it the opportunity to update, but it didn't. It does not see like the browser tabs are working very well. Maybe we should…
-
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…
