-
Report grouping glitch?
Hi there, I am confused about something. I have a report pulling data from multiple sheets. I am then grouping the data by Sheet Name. However, when I do that, the sheet names don't match. This isn't a huge problem, but it makes the associated graphs I create hard to read with the longer sheet name. The original sheets…
-
Pulling Data from SmartSheet into macro-enabled Excel?
Hello, I am new to SmartSheet and have been working on a project. Currently, the data I am working with is entered through a form by users and inputted from there into a SmartSheet. The data I am working with is free-text text boxes (so things like comments, etc.) and I was tasked with coming up with a way to sort through…
-
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…
-
Nested =IF() Issue - Logical statements are being interpreted wrong(?)
I'm having an issue with the Logical Statements when using nested =IF() statements. Essentially, it's not following the Logical Statements correctly. Here is an example of a formula that is failing: =IF([Surplus]@row = [Deficit]@row, "No Variance", IF([Surplus]@row > [Deficit]@row, (([Surplus]@row - [Deficit]@row) +"…
-
We have two forms where data is being submitted but it is not transferring to the Smartsheet grid.
Something is amiss. We have received submissions from two Smartsheets where the data is not transferring. One sheet has 14 submissions and the other has 18 submissions. Where's the data? Is it lost for good or is it just out there in the data sphere looking for a place to go? This is the first time that we have encountered…
-
Linked Source Sheet Not Automatically Updating
Hello, I am working on creating a sheet that utilized data from a master sheet via links. I am struggling because the new sheet is not automatically updating when new info is added from the master sheet which essentially makes it useless. Is there a way around this? For what I am trying to create, I need the full…
-
Automatically populate "Duration" column
Hi all, I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated…
-
How can I create a chart on the dashboard with multiple lines showing trends?
I have a sheet below that will be updated every month. The goal is to see trends throughout the month. There will be separate charts for the last 2 columns (Claims and $ Value). What my thinking is having Month on the Horizontal Axis and Claims or $ Value on the Vertical Axis. There will be 22 lines, each representing a…
-
When I upgraded from a trial account to a paid 'Pro' account I lost access to certain functions.
Hello, I recently upgraded my account from a trial to a Pro account and I am unable to do certain things. I am able to click 'Add column right' or 'Add column left' but not actually able to add a column. Additionally, certain functions are greyed out, such as 'delete column' and 'rename column'. I checked and I am still…
-
Is there any way to retrieve data that was deleted from a sheet?
If a grid sheet had 1879 rows of data in it and all of those rows were deleted, is there any way to get all of the deleted data back after it's been saved? I tried looking at the Activity Log but it doesn't show the data and I need it restored in the columns it belongs to. Is this possible?
