-
Need Help Calculating % Change (increase or decrease) Between Two Numbers
Hi everyone -- I am new to Smartsheet and writing formulas and I've searched high and low in the community here to try to figure out how to calculate the % change, increase or decrease. I need to pull WoW numbers for a report to monitor the ups or downs in that %, but I'm having a difficult time figuring this out. I first…
-
Formula to enter date once a task is complete or criteria is met
Within our task list, we are trying to avoid additional work but having the date entered (in 'DATE COMPLETED' column) automatically once another field is either 'Complete' or 'N/A' ( Complete & N/A are 2 options from a dropdown list in another column. Thank you!
-
How to create a date to show the first date of the previous quarter
Hi, I am trying to find a formula that returns the first day of the previous quarter based on a date column (TODAY). Examples (DD/MM/YYYY): -if the date column is 02/01/2024, the formula should return 01/10/2023 -if date column is 31/06/2023, the formula should return 01/01/2023 Any help would be much appreciated. Thanks…
-
Cross Reference Report - Workaround Ideas
Hi, I know that I cannot cross reference a report; I'm hoping someone might have an idea on a workaround. I have a report that gathers data from all sheets in a specific folder. The quantity of sheets varies around +/- 200. I want to get one summary field (to match on) and the sheet link from each sheet into another sheet.…
-
Fiscal Month Formula
I have been upgraded from excel to Smart Sheet and most of my formulas are able to be translated into Smart Sheet. I am having an issue with taking a date that someone enters and converting into our fiscal. The fiscal months are the same as the calendar month but the month starts on the 22nd of the prior month. So for…
-
Override Column Formula for Particular Cells
It would be great if we could edit single cells within a column that has a column formula in place without having to convert it back to a Cell Formula! That way if we have accurate data for one cell, we can change it and still keep the formula for the rest of the column!
-
Help With Auto setting Fiscal Year based on Order Date
Good morning, I seem to be having trouble with setting my Fiscal Year on a sheet. It was working but stopped. This is what I am working with: I am importing a CSV file using Data Shuttle to import SKU information into an Import Result sheet. I am attempting to set a column up to display the Fiscal Year based on the date…
-
Easy way to count unchecked boxes in a column
Hi there, I'm trying to create a reference that counts the number of unchecked boxes in a column from one of my form-filled Smartsheets. I'm trying to use the formula "=COUNTIF([column2]:[column2],=false)", where "[column2]" is my checkbox column. The problem I'm having is that using this formula counts all pre-generated…
-
Index Collect Formula with Specific Text
Hello, We have one sheet with all of our projects in a column with various other columns of data associated. I am hoping to determine the best formula to look at all project names on this sheet and return them all to a column on new sheet if they have "Cliff" in the project name. I have tried a few different ways and none…
-
SUMIFS Formula for Budget Statistics
Hi All! I am trying to write a formula to calculate budget totals based on allocation total, allocation category, fiscal month, and fiscal year. I only want to capture allocation totals made for the current fiscal year, July 2023 through June 2024. My Environment: I have a Budget Project Sheet with a form for the user to…
