-
Issue with Column Formulas and Form Questions
I created a form, and a smartsheet to correspond with it. I saved it, and all of my questions on the form are perfect. All of the rows on my smartsheet are perfect. I created a formula using =INDEX and when it's a cell formula, the questions on my form are fine. However, as soon as I convert to column formula, the question…
-
Return "Next" when the row above in primary column is not blank and row below is blank
Example based on the image: if column "ID" row 2 is not blank and column "ID" row 4 is blank, then column "Next" row 3 will say Next and all other cells will be blank. This will be ongoing so needs to be a column formula so I can assign the Next available license. Note: I've been going at it for days using the community…
-
How to total spend by month?
I am new to smart sheet attempting to create a budget tracker and will need to total the spend by month, for now just using actual spend. I tried a formula I saw online and keep receiving unparseable, could be user error though. Attaching a screenshot of the headers I am using and some fake data for testing. I may either…
-
Abbreviate year that is returned using formula (to obtain fiscal year quarter)
Happy new year Smartsheet crew! I'm returning the quarter of my end date using this formula: =IF(MONTH([End Date]@row) <= 3, "Q4", IF(MONTH([End Date]@row) <= 6, "Q1", IF(MONTH([End Date]@row) <= 9, "Q2", "Q3"))) And the Fiscal Year using this: =IF(MONTH([End Date]@row) > 3, YEAR([End Date]@row) + 1, YEAR([End Date]@row))…
-
VLOOKUP - cross referencing two data sources
Hi All, Beginner user here :) I would like to cross reference a member number on a sheet that is generated by a form to a master list on another sheet to see if that member has submitted the form. This will allow me to check who has not sent in a form so I can send a reminder email. I'm thinking using the VLOOKUP formula…
-
Not all my data is transferring from one sheet to another
I have a sheet set up to collect data from another sheet and only 15 of the rows are showing up completely and the 16th row is populating except for the autonumbering. All my formulas are set up as column formulas. There are 29 responses on my data collection sheet. What am I missing? I am missing almost half my entries! I…
-
if and formula not working
Hi, looking for help on this formula I would like for two conditions to be met for the total contract hours value to count towards the sum of the column. so if the PIP type is equal to "CE PIP AC" and the status ball is green then the hours for that row should count in my sum. I hope that makes sense. =IF(AND([PIP…
-
Formula to find the the highest sum of a consecutive list of data
I need help trying to figure out a formula that will find the max consumption qty of a particular item on a given day. The tricky part is that there are multiple instances per day of consumption for each item. It would need to to understand that each day is also a unique identifier and sum accordingly per item.
-
Need help creating formula to show # of Children that are complete & percentage
Should display something like: 2/10 (20%) # completed tasks / total tasks (percentage of total) Can you please help?
-
Formula Issue
Hello! I am trying to reference another sheet column to show how many tours were in 2023. I cannot figure out where I messed up in the formula. Any help would be greatly appreciated! Current formula I am trying: =COUNTIFS({Stanford Hospital Tour Request Range 7})([Tour Date]:[Tour Date], IFERROR(YEAR(@cell), 0) = 2023)