-
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…
-
Formula Cell Reference Limit (25,000,000) Not Refreshing
Hi all, We're having an issue where the 25,000,000 formula cell reference limit was reached after adding a new column, but even after deleting way more columns and cell references than we added, it's still showing the attached error message and not letting us move any new rows into the sheet. We should be far below the…
-
Attach checkbox column in the source sheet to a specific user per row.
Hi! I am trying to create DVs from this sheet that will do the following: In this screenshot example - Elizabeth is the roadmap owner, but Deb is the Calendar invite owner. So in Elizabeth's DV, I still need her to be able to see this row, but not be able to edit the Calendar Update Complete column. In Deb's DV, I need her…
-
Can you have a column showing a driving predecessor for a task?
In my job as a scheduler a common question is "which of the predecessors for this activity is driving the date?" Currently I have to rely on my own knowledge of my schedules or, worst case, I have to look at every predecessor until I find the one I am looking for. Microsoft Project is nice because it has the "inspect"…
-
Some Users unable to submit smartsheet forms & some users not receiving attachments in automated email
Hello, We recently launched a regional initiative to request purchase orders via a Smartsheet form. There's about 60 submissions per day. We've experienced issues with some users who suddenly lose the ability to submit the form and is causing a bit of a headache trying to manage this. We've investigated all sorts of…
-
I need help creating a formula
Background: I have Control Center, we run in Sprints. I need help creating a formula that will automatically add hours to the "Resource Capacity" sheet as they are added to any project plan, and added to the correct sprint (this is a column in each project plan) by the person @row. I have created an "Hours Assigned" report…
-
Displaying an overall completion % within a dashboard
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
-
HTML NOT WORKING ON FORMS
Hi We have used the forms for over 12 months and once the form is filled in, the confirmation message used to show hyper links however since yesterday it just shows HTML code and nothing has changed, I have cheked the code is valid and it is ?? FORM SAVED SUCCESSFULLY <a…
-
Sum if Multiple criteria matches across 2 sheets
Hi, I have two sheets containing a table of items. Sheet 1 is for entire item list and sheet 2 is for items used in a day. I want the sheet 1 to check the sheet 2 and reduce the numbers in the sheet 1 automatically. The problem I need to match two criterias. I tried following after making it work for one criteria. Any help…
-
Helper Formula for filtering contradicting Status
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
-
Problems with turning off automatic backups
I am trying to turn off weekly backups, but it's not checked and it shows no history, yet I get backups every week. Is this a bug or there is another place I have to disable it? If it's the right place, why is there no history now?