-
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?
-
How to Get "Responsible Email"
Hello @Everyone, I'm new here in the community, hoping to get support from someone who have work on the same use case I have below. Use Case: I have 2 tables, 1st table (Stakeholder Database) with column names Name and Email. 2nd table, (Sender Tool), with column names Responsible Name and Responsible Email. I want to seek…
-
Smartsheet Icons for Flowcharts
Hi all, I'm trying to make a simple flowchart explaining how a solution I built works. Smartsheet does it this way, and I'd like to replicate it: Does anyone know where to get these icons?