-
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…
-
Merged: Override Column Formula for Particular Cells
This discussion has been merged.
-
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…
-
Need to import the Yes/No result from one sheet into another sheet
Hey, I'm trying to return the Yes/No value from one sheet based on an employees name into another sheet, and I'm struggling. In the sheet A I created a new column called Eligible to Drive? In Sheet B we have a drop down that has a Yes/No dropdown to answer that question. How do I get the Yes/No answer imported to Sheet A…
-
Return cells containing numbers as text string
how can I keep the number formatting of a cell in a formula? If I want to combine text and number, it reverts the number format to the blank number without decimals and thousands separator.
-
Merged: Report Totals Printable
This discussion has been merged.
-
Need help with multiple nested ANDs
I'm pretty new to smartsheets and can't quite get the syntax right for what I'm trying to get at. This is what I'm trying to achieve in plain language: IF YEAR([Due Date]@row) = YEAR(TODAY()) AND(WEEKNUMBER([Due Date]@row) = 52 AND WEEKNUMBER(TODAY()) = 1) THEN "This Week" ELSE "Not This Week" END Thanks for any help!