Discussion List
Outbound Cell Limit - Who's Calling Me? (Outbound Cell References)
@Andrée Starå @Paul Newcome @Genevieve P. I understand from a different post that there is a 25 million limit on outbound cell references. Is there any method to find out who's calling the master lookup (source) sheet? A list of all sheets that reference the Lookup sheet? What about pivots and DataMesh - any ability to…
How do I prevent a category from showing up multiple times in a Pie/Donut Chart?
I made a pie chart from one of my sheets. I wanted to show how much was spent based on each category. However, in the widget it shows two of the same category in different slices. I'll include an example. Why is eLearning showing up as two separate parts instead of combined? Its the same category.
% Complete Without Dates
Hey There, I work for a construction company, and one of our subdivisions has multiple townhome blocks. We are currently building 3 blocks, but don't know when we will start the other ones (all dependent on sales) I'm wondering if there is a way to get the % Complete for the whole project, not just the blocks currently in…
COUNTIFS not picking up some values - Name / Email
I am trying to count the number of Submissions by Submitter. The Submitter uses a Form to enter a line on the Sheet. They identify themselves by email address on the Form. The COUNTIFS formula I'm using at first seemed to get hung up on whether the form displayed a name (for the contact) or the email address. I've updated…
Fix merge save
Formula guidance
Hi guys! I am trying to help fix a sheet that was built by someone else, and that person is no longer working for the company. They have a Dashboard that pulls data from a metrics sheet, that pulls data from a main data sheet. It looks to me like the sheet was moved or something, as it appears to have disconnected from the…
Automation: How to setup a recurring reminder based on a date in a cell in the sheet?
Hi folks! I want to setup a reminder automation. I want this automation to to trigger each week from a date in a cell in the sheet. So, if the date in the cell is 6/1/22, the automation should trigger on 6/8/22, 6/15/22, 6/22/22, etc... The only option I see for recurrence is to have it recur on a particular day of the…
Can I set a recurring event and reminder in Smartsheet?
I have a project plan that I am working on that requires certain tasks to be completed weekly, monthly, or quarterly. Is there a formula or automation that can be used to make a task recurring?
Having trouble comparing two cells
I'm having some issue with comparing two cells in my Smartsheet. I want the box to be checked if the cells match, and if not, the value of the one on the left should turn red. I have 8 sheets for 8 different budget accounts that are all based on the same template. This works for every one of them except for this one. In…
Autofill Form Title on sheet
I have a sheet with 3 forms and I'd like the title of the form to show on the sheet when the information is submitted. I prefer that this be autofilled and not visible to those completing the sheet. Is this possible?