-
Avoiding a massive nested IF formula - checkboxes?
Hi all, I have 5 check boxes and based on these being ticked or unticked i want to display something in another cell. It is essentially a decision tree that simply i want to work as follows: If Group 2 is not ticked (or nothing ticked) = Group 1 If Group 2 is ticked but 3, 4, 5 & Close are not = Group 2 If Groups 2 & 3 are…
-
How do I hide names in Gantt Chart?
I created a schedule and assigned task to the resources names. The names are showing up in the Gantt chart. How do I hide names ?
-
How do you create a contact list based on 2 seperate sheets using a Vlookup.
Hello, Looking for some assistance with an issue we are having populating contact lists based on 2 separate sheets using a vlookup. To summarize the attachment, we have a sheet with a list of account owners and their email addresses (Client Services Listing) that is feeding into another sheet (CSLS Teams by Account) which…
-
Is there a way to force a Dynamic View logout when the session ends?
Currently, it is possible to be logged in Smartsheet and Dynamic View under two different accounts, simultaneously, on the same machine. Unless a user explicitly logs out of Dynamic View or clears the browser cache, the next time Dynamic View is opened, the previous session is resumed. This presents a problem for shared…
-
Can I create one Smartsheet QR code that shows me a list of Forms to choose from?
Currently, my team has several different forms that we use to track process KPIs, or to populate other files. This means we have to post or carry around a handful of QR codes linking to those various forms. I'd much rather have one QR code to rule them all and show all the forms, click on one there and have it navigate me…
-
Expiry Dates - Compliance Check
Dear SmartSheet Community, I need your help. I need help in writing a formula that will track compliance for different areas based on expiration dates. If dates are active and will not expire in the next 30 days, health should be green. However, if one or more items in the row will expire in 30 days, yellow and anything…
-
How to reference another sheet in a formula
I've been trying to write a formula that will "Check a checkbox (in sheet A) IF [name] cell (in sheet A) is found in {name} column (in sheet B), AND the box in [checkbox] column (in sheet B) is checked." Basically, does a particular staff member's name appear on another sheet, and if so does it have a checkbox checked in…
-
Behind/Ahead of Schedule by "x" days
Hi All, I'd like to add a column that reflects how many days my project plan is ahead/behind schedule. I asked this question last year, but couldn't find it anywhere. I have a Planned Finish and a Finish Date. I'd like the row to display the following for each: If no variance, display "On Time" If late, display " X days…
-
Calculate Average if another Range meets criteria
Hello, Any suggestions on the best way to calculate the average days if the item type is equal to quarterly? I have a drop-down menu that categorizes the activities based on frequency, and another column that calculates the days past based on end and start dates. How could I find the average if the Item type is Quarterly?
-
Multiple conditions in a formula
Help please. I have no idea how to combine formulas. I just want to round up this 6.83 to 7. What am I doing wrong? I don't want to use the "move over 2 decimal places" in the menu bar above because I need to take the rounded number and times it by a price per hour to get the Cost in another area of my sheet.
