-
#INVALID DATA TYPE formula Return
The first formula below is returning a #INVALID DATA TYPE when I enter it. But in the second formula the equation works and I am not sure why the first one is not. What am I doing wrong with the Fiscal year part? does not work: =SUMIFS([Total With Service Charge (18%) if Applicable]:[Total With Service Charge (18%) if…
-
Best way to calculate stats on a sheet tracking form submissions
I have a SmartSheet that logs "installation issues" as they are submitted via web form. The sheet tracks the "locations" id number, address, owner, manager, issue, issue type, and who is working on the issue. Its a tracker you could say. I want to be able to calculate how many of "issue type" A or B have been submitted via…
-
Undo question
Hello, I was editing a formula and somehow the whole sheet appeared with the error #INVALID OPERATION. I was trying to undo the last change to reverse it, but the button wouldn't appear enable and the sheet was saved! I invested a lot of time ==(. Is there anyway to recover the previous version of my sheet? Thank you.
-
Referencing another sheet using vlookup
Today's my first day using Smartsheet; I referenced another sheet for columns that I needed. Now rows that are not found in my specified range are auto populated with "#NO MATCH." I need guidance for making the "no match" blank. I tried an if statement but still having the same issue.
-
Successor Column
Hello, Could the SmartSheet community get an update on the successor column from the products team? I believe this was first requested a few years ago in late 2015 and has been by others multiple times since then. Thanks, Riley
-
Updating Info on the Projects Index Sheet
Hi all, Consider that I have an index sheet that lists all the projects (active or not), with the current task, it's description, timescale, owner of the task, and also the task that will come next. Parallel to that, I have individual sheets for each project that list all the information above, and also all the remaining…
-
Inserting New Columns and copying formatting
I have a sheet where I need to add some more columns in the middle, however when I go to insert the columns, the formatting and coloring of the cells follows the columns at the end of the sheet, rather than those on either side of it. Does anyone know how to make it so that when you hit "Insert Column Right" or Insert…
-
Sync cells content according to date in different sheets
Hi there, I'm new to Smart Sheets and I'm trying to achieve the following. I'll try to explain. I have manually created a calendar, in normal grid mode, which has a 3 month view side by side with blanck cells next to each day where i can manually add content. I have another sheet, in card mode, where I can manage basic…
-
Bar Code Scanning for event registration
I am an event coordinator, and use Smartsheet mainly for managing my events. It is a great tool for keeping track of to do lists, timelines and event details. I even use it to collect RSVPs. What I'm wondering is if anyone here uses Smartshee's bar code scanner for event check-ins, or if anyone uses a third party…
-
Using Reports / Dashboards for Analytics Recaps?
Hey there! I'm currently tracking our sales analytics using a smartsheet. Column A lists all of my metrics and then i create a column for each week. As the weeks progress, i fill in the rows with sales data. I'd like to create a Dashboard that shows me the data from the last column (most recent week ending) on this…