-
My first automatic RYG/RAG schedule status formulas
Hi everyone. This is my first new discussion. I wanted to share some automation I put into my schedule that made it much more friendly. First, I have a few key columns: * Status (Drop-down, manual entry, "Not Started" or "In Progress" or "Completed") * % (Manual, progress on completing a task) * RAG (Automatic, shows Red,…
-
Is it possible to grant access to a folder without granting access to the whole workspace?
Im hoping someone can help me out, I am fairly new to SmartSheets. In my organization, we have created a Workspace called PMO - Projects. This workspace has a folder for each department and within each department there is a folder for each project we are running specifically for that department. We have configure this to…
-
HOW DO I CREATE ROW HEADERS that cross multiple cells?
Can I eliminate the "lines" between cells to give the appearance of a header? Can I create a header that automatically crosses several columns since there is no "MERGE" option??
-
merge cells
Hello everyone, Is there any way to merge cells in Smartsheet? Thank you in advance!
-
Can I filter with a date formula?
I'd like to filter to show "Open tasks and recently closed tasks". I have this working but "recently closed tasks" is hard coded to ">= March 1, 2017". Can I use a formula for this? I tried to use "=Today()" but that says "Invalid Date" (with or without the quotes). Is this possible?
-
Dark Mode
Can we get a dark mode? something like the dark neutral theme but has dark cells as well so it is easier on the eyes.
-
Reference Entire Column in Function
Hello Team, I wish to reference an entire column in a function, for example: Current Function: =SUMIF([Task Owner]1:[Task Owner]82, "Text", [Resource Sum Column]1:[Resource Sum Column]82) / 100 Desired Function: =SUMIF([Task Owner]:[Task Owner], "Text", [Resource Sum Column]:[Resource Sum Column]) / 100 Is this possible? I…
-
Current w/c date
I need a formula that will return the date of Monday for the current week. So on Monday 08/05/2017 it will show 08/05/2017, but on Wednesday 10/05/2017 it will still show 08/05/2017. Please help!
-
Feature Request: Barcodes & QR codes read/generate/print
Barcodes and QR codes are very useful for invenory management, and simply avoiding mistakes when entering data. They are also a great way to share things quickly (ala WeChat users) I think it would be great if we could add this into SS. 1. Ability to scan/accept Barcodes/QR codes - usually the easy part. 2. Ability to…
-
Do not show parent row in calendar view
Hi, Is there a way to set up hierarchy with several tasks and different dates, and not have the parent row's date, which ranges from the first to the last date in the tasks below it, show in calendar view? I want just the children rows to show, so to keep my calendar cleaner. Thanks for any help
