-
Vacation Days Formula - calculating half days
Hi, I am trying to incorporate 0.5 days of annual leave into my vacation tracker. I have the forumla =NETWORKDAYS([Start Date]@row, [End Date]@row, {Bank Holiday Lookp}) to calculate overall number of days out (minus public holidays). From this total I then want to include any 0.5 days from this when 'half day requested'…
-
webhook suddenly stopped working.
I created a Smartsheet webhook last month, and it was working fine. However, from yesterday it stopped working. I faced the same problem before, so I created a new webhook, but now, even the second webhook stopped working. Can you help me understand the reason for this issue?..
-
Change of Symbol Value Colors
Hello- Is there a way to change the colors in these selections? e.g., I want to have "Orange" instead of "Yellow" and "Dark Green" instead of "Blue." =IF(Outcome@row = "Zero", "Red", IF(Outcome@row = "Check Minus", "Yellow", IF(Outcome@row = "Check", "Green", IF(Outcome@row = "Check Plus", "Blue"))))
-
Merged: Favorites List Sort/Display Order
This discussion has been merged.
-
Restore Specific Cell Range
It would be helpful to be able to restore a specific cell range to a previous date. For example, if a team member incorrectly modifies an entire column in a report or clears the data in the column accidentally and saves, and no one notices or reports the problem until after a significant amount of other data has been…
-
Get multiple pages of data in Bridge
Hi all I just wanted to pass along a pro-tip that I got from the Technical Engineering group at ENGAGE 23. If you need to deal with paged data in Bridge, it's not immediately obvious how to do that. At least not to me :-) So I asked. For example, if you do a List Sheets in Bridge, you may get some of the data back on page…
-
Drag drop photos into Cell
Currently, if you drag a photo to any Row it attaches this. I love this BUT when I want a photo in a cell, I have to Insert and browse. Options for Idea. Drag and drop, give an option for photos to be attached or go in cell right-click, insert image, allow drag and drop into a box to put it in a cell. Photos in cells are…
-
Can I pull columns in different Sheets in one report as long as Primary Column is the same?
Dear All: I tried the Community and I came up with nothing. Can I pull different columns in different Sheets in one report as long as the Primary Column is the same? The columns I need exist in different Sheets, not all Sheets have all the columns. However, the Primary Column is the same (“Interpreter Name” as Text/Number,…
-
Date Calculations
Hey y'all super new to this, I am trying to have the goal date be based on the Target open date less the days prior. The formula I have is " =Description1 + [Days Prior to Opening]@row " which returns the above. What am I doing wrong and how to do I fix it? Dependencies are turned off.
-
Update Column with Global Updates without Changing Position
I want to be able to choose whether or not the position of a column changes when I use the "Modify Column" global update. This can be very disruptive to my users if they have rearranged columns on their project sheets.