-
Change cell color based on date from another sheet
Hello! I'm working on a project overview sheet for many overlapping timelines. I'd like to make it so that if any of the projects have the date that the column is named that cell highlights or changes color. So, for example, if project 1 timeline had a date associated with 9/12/21 then the cell joining those two would…
-
Show % progress on bars in Gannt view
Been searching and can not find any clear answer to this so ill ask (maybe again). Is there a way of presenting the % progress within the bar of a task in Gannt view as it is as default in MS Project for example? It could be enough to have it in 25,50,75,100% increments for me
-
COUNTIFS Issues
I am having problems getting COUNTIFS to work. I have two different formulas I am trying to set-up in different columns. I would also like cells that return as zero to change to blank. Does anyone know how I can fix my formulas and also set them up for "0" to change to blank? 1.) I need a formula that counts the amount of…
-
Default view when a user opens a sheet
Hello! What is the default view for a unlicensed user when they open a sheet? (In regards to collapsed and expanded rows) Is it the same as the last way they viewed it, or how the last user had viewed it? Here is the specific question from my colleague: "Usually when I'm done with a set of tasks I like to collapse them…
-
Change Status if Date Completed is not blank
Our team has a sheet to track all of our tasks - who it's assigned to, when it's due, date it's completed, the status (requested, assigned, complete), etc. We have people updating the "Date Completed" column, but forgetting to update the "Status" column to "Complete" (The "Status" column is a drop down column). Is there a…
-
Workflow email content based on conditions/critieria
Hi All I'm very very new to SS (just got a license today) and I've been included in a team to improve the notification process to our wider audience with key information to help them complete actions quicker with minimum TLDR! Is it possible to take the column header and add the text to the output notification (email) if a…
-
Can I setup conditional formatting based on a time function?
Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.
-
Counting checkbox's for children without counting the parent
OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this? If the "Is there a color image?" box then the row will be counted. My goal is to have a total count of images that we have a color version for. the URL is on a row…
-
How to input a date/time and calculate a time elapsed?
I'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is =(Time1-Time2)*1440 which gives me a total time elapsed in minutes. I then build my dashboards to take those calculated fields and do…
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
