-
Using an IF formula for Parents, Children rows
Hi all, I'm currently trying to see if there's a formula that can be used to affect the parent row (row above the indented row) after a certain condition has been met within the children row (indented rows). Please see the image as a reference. In this example I've set up, I'm trying to figure out if there's a formula that…
-
Project Milestones Metric Help
Hi, I'm a newbie SmartSheet Admin for my organization and am still trying to get my head around some of the ins and outs of the tool, so apologies if this is a basic question! At my organization, one of the core metrics we're supposed to report on is the number of project milestones completed within +/- 4 weeks of the…
-
Trying to combine 2 formulas into one, each formula with multiple conditions
Hi All, I'm fairly new to formulas here on Smartsheet and have been racking my head over this one to no avail so far. I basically have two formulas that I am trying to combine into one, and each formula has multiple conditions. In the first formula, the conditions to be met are that if both columns of Date Received are not…
-
Help with a formula to auto number
Hello! I have a need to create / automate a few subcategories when a new row is added to a sheet. Here is what I'm looking at. You can see in the 'Budget Action Requested' column there are Initial actions and Amendments. The Unique ID column next to it collects data about the study to assist in populating the row using…
-
How to set up a formula to get around timestamps?
I have the search send over as a csv, but it has the date field formatted differently than how Smartsheet sees date fields. I occasionally run into this issue when I use the date field from the system notes in NetSuite. Is there a formula that could be set up to get around this? I have the column set up as a date field…
-
No idea where to start?!?!?
Hi all! New to smartsheet and struggling with formulas. Here is the sheet I am currently working with (Sheet A) I want the column labeled DC AVG to populate the total AVG for all Doc Control lines, from the Date of Inspection and any dates prior. (I manually populated the existing data in DC AVG) Similarly for LP AVG, I…
-
Countifs w/ two date ranges and two different sheet
Hello All, I am trying to count the number of projects within the same date range, but there are two different sheets I need to pull this from. I keep getting an INCORRECT ARGUEMENT SET. Here's the idea of what I have: =COUNTIFS({Sheet1}, Criterion1 , {Sheet1 Date Range}, AND(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023,…
-
Is there a way to weight the average in a sheet summary report?
I have a report that pulls from the sheet summaries of multiple sheets. One of the fields divides two other fields to show the % of items completed. However, when grouping & adding summaries to each column, the % completed summary averages the values below it rather than showing the actual % of items completed. In the…
-
What formula do i use for date ranges = Priority?
I have a priority column I have a invoice date column I require a formula that changes the priority: to high for anything over 90 days old of the invoice date To medium for anything between 61 - 89 days old of the invoice date To low for anything 0 to 60 days old from the invoice date can anyone help with a formula and/or…
-
Is there an automation/formula that allows a copied row to be updated?
I have created a master sheet for grant invoicing. We have 14 different institutions who received the grant and who will be submitting invoices to the master sheet. I have created a workflow for each institution so that when they submit to the master sheet, that row will be copied to a separate Smartsheet with just the…
