-
Select Entire Coloumn in Sheet Summary Formula
This might seem super basic, but I am trying to build a formula in a sheet summary and want to define an entire column as the rane. I know that it should look like [Column Name]:[Column Name] but is there any way to select the whole column to automatically insert that synax into the formula without having to type it out?
-
Automated Alert to Someone Based on Parent Info only - not children
Hello - I need help creating an automated notification. I want someone to be notified when a project status = Complete. I created an automation that works, except I only want it to work in the PARENT rows, not any of the CHILDREN rows. I can't figure it out. Thank you!
-
Searching formula for index/match, searching for matching value on multiple sheets
Hello all, I'm a newbie and am getting stuck trying to find the correct formula to return an ID associated with a person when searching for this person across multiple sheets. I'm familiar with INDEX/MATCH, but am having trouble figuring out what function to combine with it. Example: Homer has a record in Sheet Aβ¦
-
Average IF or Avg(Collect) to obtain the average of multiple scoring values
Hello Everyone... I am a bit new to Smartsheet and trying to find my way. I have an issue where I have an external reference to a 2nd sheet to collect a point total for how thoroughly some questions are being answered. I have up to 8 different people who will be scoring the responses and these scores will be tied to theβ¦
-
Countifs and Is not blank
I am trying to create a formula where it counts the number of rows when an invoice has not been approved. This is what I have and instead of changing the name for each person, I want to create one where it counts when the Approver column is not blank. =COUNTIFS({Approver4}, "Eric Delie", {Hold}, "")
-
Summing entire sheet, but only higher number with similar items.
Okay so I'm trying to create a rough budget for a project, but have received multiple bids for some categories. I want to sum all the items cost, but with multiple items, only take the higher cost. Here's roughly what I mean: Item Price Appliances 12000 Appliances 10000 Glass 8000 Stone 7000 So I want to sum the priceβ¦
-
Repeating # formula
this is what i have - but not working IF([row #]18, =1, "2", OR(IF([row #]18, =2, "3", OR(IF([row #]18, =3, "4", OR(IF([row #]18, =4, "5", OR(IF([row #]18, =5, "6", OR(IF([row #]18, =6, "7", OR(IF([row #]18, =7, "8", OR(IF([row #]18, =8, "9", OR(IF([row #]18, =9, "1", i want if the row above is a 1, the next row to equal 2β¦
-
Looking to time stamp when a box is checked
When a box is checked, I would like to add a time stamp of when that happens. I can put together a formula that involves today's date but I do not want that date field to change every time the sheet is refreshed. I want to be able to run reports capturing start and end dates for project phases. Does anyone know if it'sβ¦
-
Formulas -Automated at risk status
Hi all, I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist. Red: % Done is equal to 0% and the Start Date has passed Yellow: % Done is bigger than 1% Green: % Done is 100% the formula I'm coming is this: =IF([% Done]1β¦
-
Resources Tracking
Hello anyone, Please i need some help. My goal is to be able track resources and show forecast in the resource view. If I am correct. i know i have do some calculations or use formulas which i have problem doing that. The data presented to me was Title of the Resource # of people that work in June-Sept total hours worked iβ¦