-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
COUNTIF + LAST YEAR INFO
=COUNTIFS({M&A Program Interest}, CONTAINS("Buyer Consult", @cell), {M&A Intake Form Range 1}, @cell > YEAR Trying to utilize this formula; pull metrics from the past year only.
-
Quarter Differentials
Hello! I need to create a formula showing the differentials between quarters for two types of data - the total users and total shares for social media posts entered in the sheet. I created fields for Q2 User Differential and Q2 Total Share Differential and assume I'll need Sum and IF logic built in. For the Q2…
-
Find Unique cell in a column.
We are trying to move some Excel sheets into Smartsheet! In Excel, we have an address list in a sheet named “Main” and another sheet named “Street“. We extract the unique street names from “Main” and list them in “Street” and we count the number of duplicates of the streets name. My little sample has 7 addresses – the…
-
Formula using SumsIF
Hi Everyone, I need assistance on a formula I want to sum the numbers in the "Qty of Monitors" column if the Office column is "SOMA" and when the dropdowns are " Acer AND Viewsonic" are both selected in the Monitor column. Formula I have put together=SUMIFS({Qty of Monitor}, {Office}, "SOMA", {Monitor}, "Viewsonic",…
-
COUNTA alternative in Smartsheet
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available in Smartsheet (COUNTA). When I've tried to replicate it I get an error message (UNPARSEABLE) The formulas are:…
-
How to create Letters automatically from a number contained in another field.
**Translated via Google Translate as the Community is only supported in English at this time** Hello everyone. I greatly appreciate guidance with the following: I want to know if Smartsheet has any formula, add-on or integration that automatically generates letters in one column corresponding to the numbers contained in…
-
how can I copy content of 1 column in report into a different sheet
Hi All! I am looking for a solution that will automatically copy the content of one column into a column in a different sheet. Is there a way to connect a report to a sheet in a way that will allow Smartsheet to automatically copy the data in one report column to column in a sheet? To give a little background: I have a…
-
Service log / mileage tracker
I am using a form which has an individual input the current mileage of a vehicle every time they use it. This would need serviced every x amount of miles. I am wanting to set up an automation that will email a specific person whenever it's time to service the vehicle. I guess right now I am trying to find a way to do this…
-
Is there a limit to how many rows a function can search, for an IF statement? Having data not show.
For a requisition database, I maintain a pool sheet of available equipment, as well as sheets for orders and the vendor. I have formulas in a different sheet to add the VINs (let's say 5) that I am planning to add and it checks across the other sheets if that VIN exists. On this "check" sheet, I've noticed some VINs will…
-
I am trying to compare 2 date columns with an odd result
I am trying to count the number of submissions on a daily basis with =COUNTIF({Loans Range 1}, =[Begin Date]@row). Most of the formulas return the correct number of submissions. What it looks like it is doing is applying the submissions entered after a certain time (5 PM?) to the next day. Dependencies are disabled…
