-
Have a formula that numbers rows and want it to only count certain rows
Hello, I want to sort items by priority based on order of the rows in the Smartsheet. So, I want lower numbers (rows towards the top) to be shown as a higher prority. I am using the formula: =MATCH([Task Name]@row, [Task Name]:[Task Name], 0) However, I also want to only include certain rows. In particular, I want to only…
-
SUMIFS with 2 criteria coming up zero
Hi! This formula keeps returning a zero. I am trying to get it to count two different things in the same column (not sure why they were labeled differently) but when I get the formula plugged in it comes back with zero, when I know that's wrong. I want it to count up the engineering hours based on the product lead,…
-
INDEX/COLLECT Q: Running into issues pulling data from another sheet based on 2 criteria
I am attempting to pull attendee numbers from a master grid to a summary sheet. Our master grid has upwards of 30 columns and is used as a central repository for event-related information across multiple years. I have been tasked with compiling a dashboard for our senior/executive leadership to showcase the total # of…
-
Sum Time Difference in Quarters between 2 Columns
Is there a way to sum the time difference between two columns There is two columns "Start Time" and "End Time". If Start Time = 1800 and End Time = 0600, which falls on the next day. I would need it to calculate 12 hours If Start Time = 1845 and End Time = 0600, which falls on the next day. I would need it to calculate…
-
Is it possible to do calculations between Summaries of 2 different Sheets?
Hello, I'd like to calculate a value that is simply a subtraction of Summary fields on 2 different Sheets. It's ok if the calculation formula is on a sheet, a report, or a dashboard, doesn't matter. I just need Smartsheet to subtract the two Summary fields. I am a beginner user so any help is appreciated. :) Thank you!
-
Calculating a date up to 60 months in future
I need to calculate a future date from a past date + a number of months. I have a working formula but it breaks after 14 MONTHS . I think it creates some sort of circular reference error after it passes the current MONTH in the following YEAR but am so far unable to correct the issue. I think i need to nest some additional…
-
Predict or set which row a form writes to
I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…
-
IF Statement Returning Incorrect results
I tried the AI feature for writing formulas and it gave me a slight variation of the formula below. I want it to look at the Discovery Completed column and if the box is checked then it should display the information in the cell for the Implementation Project Stage. If the box in Discovery Completed is not checked then it…
-
If Cell A is NOT blank AND Cell B is Not blank
I'm having trouble with my syntax I believe. I need to determine if Cell A AND Cell B are NOT BLANK then execute a function otherwise leave Cell C blank. The below is what I thought would work, however, I'm getting 'unpaseable' =IF(AND(NOT(ISBLANK([Case Product Removed]@row)), (NOT(ISBLANK([Case Product Re-Stocked]@row)),…
-
DAY Function
Hi everyone - I have 2 helper columns (Column Names: Apps scheduled for today and Apps scheduled yesterday) that is supposed to look at the create date and today's date to determine if a checkbox should be checked or not. Here are the formulas: Apps scheduled for today: =IF(AND(YEAR(Created@row) = YEAR(TODAY()),…
