-
Count children but only some of them
How should this formula look if I want to only count children that are 'Open'? ="Project stage name - " + COUNT(CHILDREN()) I am using on the parent row in a project risk register so I can collapse stages not reached to focus on the risks for the current stage. However, some of the risks in the current stage are now…
-
SUMIFS with 9 criteria
I am trying to sum specific values based on a dropdown list in one column and display that sum in another column. I have an "Amount" column , a "Total Final OEP 0708 Cost Center Spent" column , and a "Cost Center" dropdown column. I want to sum CHILD rows in column "Amount" based on the drop down option that is selected.…
-
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,…
