-
Format key and Primary Column
Hi all! I have two questions: 1. I have several conditional formatting rules that change colors or font based on contents. Can anyone recommend the best place to put the "format key" to indicate what each color and font means? I currently have it in an attachment, but that's not so easy to reference. 2. Does the Primary…
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Admin Report - Sheet Tracker
Is there a report or query that can be done from the Admin account that shows all the sheets created in our cloud instance. I see that there is a total like 363 out of 500 sheets used, but it doesn't show date, who, sheet name and current status of that sheet (archived, deleted, new, etc). Is this possible?
-
Conditional Alert enhancement status and issue with work around for alerts on incomplete tasks only
Any update on the functionality for the "Reminders" in "Alerts and Actions" to be conditional to eliminate for example tasks based on a completion condition? I used the work around proposed previously in this forum (see below suggested by @Mike Wilday) , but found this to have following limitation: Since you are using a…
-
Delete task dependency
I'm trying to delete one task dependency on a Gantt chart. I found this quick YouTube video, which says to click the dependency line, but I'm unable to click on it. My dependency lines are not green like in the YouTube video. Thoughts?
-
Feature request - dynamic lists
Dynamic lists would be a very valuable feature in smartsheet. When we add a new employee to our system, we need to add them into about 10 different sheets, so that they can select their name from the relevant lists and fill out a timesheet, project reporting etc. If the new employee could be just added to a dynamic…
-
Linking
I was wondering if smartsheet linking has the capability to perform this following type of function: If I create a Request Log spreadsheet, and one of those columns has a drop down with options, approved, hold, pending, is it possible to create a function wherein once that approved selections has been made then that row of…
-
Webhooks API
Hello, Does anyone have any good examples of using the webhooks feature of the API to send notifications to Slack? I'm not sure if I have everything structured correctly in Smartsheet but, essentially whenever a certain cell in a sheet (that could live in a specific set of Workspaces), I would like to have a slack…
-
Horizontal Reporting (Transpose)
Hi! I'm currently having some issues generating a report from smartsheets that enables be to do some additional reporting away from the product to enable external sharing (due to data, and legal reasons). I'm looking at building a milestone report however the current report that is being generated in smartsheets is more of…
-
If/Or Statement
Hello all, I am relatively new to Smartsheet and have hit a wall in trying to automate a RYG. I am looking to change the color by listing multiple possibilities from a range of cells. My idea was to create a separate column for the formula, hoping to return a "1" or a "0". Then I could add a simple formula in the RYG…
