-
How can I remove a sheet reference, so I do not receive the alert ‘Reference a total of 25000 cells
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focused data, data that should not be managed on an International sheet that already has 85…
-
Assigning tasks to group contacts
I have created several contact groups in smartsheet for entire teams that need to work on certain tasks, only to realize that these groups are not automatically included in my contact directory within the sheet itself. Is there a way to assign a row to an entire contact group without adding each individual email to…
-
Customized Buttons in Dashboard/Portal
After seeing very nice dashboard presented in Best in Class Project Management video I tried to start developing something similar for our organization. However I'm struggling with creating customized buttons (like "Home", "Portfolio Dashboard", "Departments" etc) that you can see on the top of the dashboard that is used…
-
Is there a way to stop 100% completed tasks still showing in Resource Views
We use Resource Views to show capacity loading for each department in our factory. Not sure if this is possible, but it would make sense to me if when tasks allocated to a particular resource were marked 100% complete they would no longer show/contribute to the loading of that resource. If a completed task dropped off the…
-
Help: #INCORRECT ARGUMENT SET
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLANK([2nd PRODUCT OWNER APPROVAL]@row), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED",…
-
Project Management: Automating Timelines Across Multiple Projects/Sheets
Before I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't have LiquidPlanner nor does it plan to, it's just the only product I've heard of that has this functionality out of the box.)…
-
Formula to lookup and display date based on specific task
I need to report a GO Live date on various dashboards. The problem is the go live date is not in a static row and can move up or down in the project plan based on tasks. I assumed that I could use the vlookup to find the "Go live" task and display the date but using this formula, nothing displays. I dont get an error of…
-
Microsoft Office 365 Planner support
What I'd love is for an assigned task to create a new Planner task and be linked together when changes happen to either side they update each other. Primary use case is that the majority of people who will access Smartsheet in our company will have other tasks they need to keep track of in the organization through Planner…
-
Automated Workflow Emails Look Like Span
Can I change the heading of an automated workflow email so it does not look so much like spam? I would prefer it to look like I sent the email and not the automated system.
-
Drop Down List Data Validation
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. The biggest is the inability to create a drop down list that uses data validation to pull a list of options from another Sheet. (Example - one sheet…
