-
Requesting recurring daily Backups
Hi, Is there a way to request recurring backups on a daily basis? Or can the recurring backups only be done Weekly?
-
Report on today and next workday
I'd like a Report that shows rows with the Date field from today or the next workday. That is on Monday - shows Monday/Tuesday Tuesday - shows Tuesday/Wednesday ... Friday - shows Friday/Monday Saturday - shows Saturday/Monday Sunday - shows Sunday/Monday My sheet is very complictated and starting to visibly slow down so…
-
IF Statement
I am currently working on an IF statement for RYG. I currently have a statement that turns green if the task is not on the due date and in the future. I have it turn yellow on the due date and red when past due. I am trying to get the IF to work adding grey to the mix that if the column done (checklist) is marked that it…
-
Entering Address Information
One of our users has a sheet that includes an Address field to store mailing address information. They have created this as a Text/Number field an enter multiple lines of data (c/o, address line 1, address, line 2, city/state/zip). The same Address information applies to mutliple rows of data, but currently they need to…
-
Collaboration outside our organisation
we want to collaborate on certain rows but not all rows with an external partner. is there a way we can do this without sharing all the rows in a Smartsheet?
-
Formula help - set values for current user and date when check box checked
I have a checklist I am building for a department where they will be primarily mobile users so I would like to reduce the thumb typing as much as possible. I see where I can use test the value of a checkbox and make it do things.. but what I want to do is get the current date and current user. So that when someone clicks…
-
Ability to use differnt font colors in a cell
Would anyone else find it useful to be able to use use different font color for certain words in a cell only, rather than having to change the font color of the entire cell? The ability might also be nice to be able to underline and italicize certain words in a cell as well but definitely colored font to call out…
-
Automating Grey Ball
I am having an issue getting the grey ball to work when a task has been marked done. The formula that i have is below. If will only work if the date is older than today. If will change the balls to other colors depending on the dates even if the task is marked done. Any suggestions? =IF(AND([Due Date]1 < TODAY(), Done1 =…
-
Customized Sheet Properties
I have a situation where our organization will be creating all of our project sheets through one group. This means that the project owners will be out of sync from who actually is the owner. In addition to this we would like to filter by certain project level items such as Implementation Status, Project Health, Escalation,…
-
Automating Balls
I have a formula that works for some of the functionality. I am having an issue getting the gray ball to work using this formula. =IF(AND(TODAY() - [End Date]4 > 0, [% Complete]4 < 1), "Red", IF([End Date]4 - TODAY() < 4, IF([% Complete]4 >= 0.9, "Green", IF([% Complete]4 > 0.5, "Yellow", "Red", IF(AND([End Date]4 <=…
