-
Checkbox in source sheet pulls data into destination sheet
I know reports are the more favorable way to go with this but that won't work for what I need. Use Case: Departments have a tracking sheet with high-level detail. Other departments want to track various level of detail in their own sheet. Only some of that data needs to make it back to the roll up sheet for executive…
-
default formula in hidden field
I need to reference the content from one field in another field on the same row. I want the formula as the Default Value of a hidden field on a form. The formula I'm using is =[Team Member]@row. When a new form is submitted, the field with the formula shows a single quote mark at the beginning, and therefore it's not…
-
Formula for average between 2 dates
Hi all, Probably a very stupid question, but is there a formula that presents the average date between 2 dates. For example, the average date between Monday 4th Septmeber and Wednesday 6th September should be '5th September'
-
I need help with creating a formula using Countif or Countifs.
I am trying to pull data from one range that has mulitiple values. Does anyone know how to write a formula to not pull information from more than one range? I am using the formula =countif(sheet reference data), (question ie: What do you enjoy most about your holiday party? @row. This works for when the question isn't set…
-
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…
