-
Circular Dependency error
Hello, I am getting a "Circular dependency" error when assigning a dependency, but I cannot find any circular dependencies, in fact I've just started adding the dependencies. Below is the part of the sheet where I'm having difficulty. When I try to add "199" in the depency column of any of the rows 201-204, I get the…
-
Shared Filters Not Working
In one of our sheets I want the ability to "force" users to view a sheet through a filter. We have a lot of rows that are added on a daily basis and I want those rows to be hidden if the completed column has been checked. This makes it easier to navigate the sheet and find the open actions that need to be addressed. So I…
-
Email Notification Collation
Hi SS Community I am triggering some automation within another tool when receiving an email from smartsheet notifications. The problem being sometimes smartsheet collates emails when there are a few to send and sometimes it doesn't. Is there a way to control this behaviour as it makes it harder to cater for both outcomes…
-
Linked lists and columns with attachments
I returned back to Smartsheet from testing Notion and Airtable. I do not know what this CEOs and CIOs of Smartsheet think about this two core features. This features stop companies to use SS in serious workflows. BUT this is only first two missing features in Smartsheet comparing wir]th Airtable and Notion A and N already…
-
SUMIF Multiple cell
Hi, This is to seeking help how to sum the "Down Payment" & "P.G. Billing 1" when Due Date are JAN.2019, Pls refer to the attached picture. I'm using the below formula for single column computation, =SUMIF([Due Date 1]16:[Due Date 1]24, "JAN.2019", [Down Payment]16:[Down Payment]24) But have no idea how to sum within…
-
Report Builder: Include Only Top Level Gantt Chart Rows
Hello, I'd like to design a report of overdue projects in my Gantt chart. I can easily design a report showing all incomplete, over due tasks. But what if I only want the top level items on the report ... those that are not indented? Using this forum, I read an answer to another question that prompted me to add a new…
-
Merge & Center
Hello, The "merge & center" is a formatting option I am quite fond of inside excel and curious if I can replicate this in SmartSheet. I would welcome any feedback. Sincerely, Scott
-
Brand new
Hello, I am brand new to smartsheet. I am trying to learn how to use this most effectively. How do your employees sign into the mobile app to see everything that they need to do. Is there a different login? Is it free?
-
Calendar App Add-on - New Event
Hello, Currently, I have the add new event function enabled for the calendar app. The calendar is pulling from a sheet which has a column where I am using a formula to format the event info in a way where it can be easily read by our team. Is there currently a work around to "hide" the formula column from being accessible…
-
Forms - How to get them to update a smart sheet?
If anyone can help... I created a form on issue tracking. Went to test the form and it appeared to work fine. However nothing updated in the smart sheet. Why is that? Is there something else I should be doing? Where did the update go? Why is it not posted to the sheet?
