-
Upload an attachment to Smartsheet workspace using Smartsheet sdk
We are using C# code in which we are referencing Smartsheet NuGet package. We want a sample code to upload a file attachment to workspace.
-
Populate Child due dates based on parent due date and (+/- number of days) column
I'd like to populate the due dates for child tasks based on the 'master' due date of the parent line, with the help of a "days out" or "weeks out" column. For example, I'd input the due date of the parent line below as December 31st, I'd want the child lines to populate accordingly with December 31st less the number of…
-
Referencing cells in the automation message, it is not pulling through the referenced cells?
-
Index collect formula question
Hello I need some assistance with my index collect function, In one cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, "Person 1"), 1), "") In another cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event],…
-
Increase sheet row and column limits
Hi Guys, What is the possibility to increase the row (20 000) and column capacity? I'm working for a company that headcount surpasses the 20 000 mark which makes it extremely difficult to utilize smartsheets, which we really want to do. This would truly make a huge difference in building a database etc.
-
Dashboard Widget Automation?
We have some elements we want to add to a user's dashboard only if the information is relevant to that user at that time. An example would be to have a widget showing the status of requests they have submitted only if they have submitted to a request form. Is it is possible to have a dashboard add or remove widgets based…
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
Email automation
Hello, I'm in a little pickle here. Smartsheet can send out emails through automation. Those emails, especially when include an attached file, are not professional. I saw some users literally put a disclaimer in their email to ignore the links and highlighted information, rows, etc. That format is not acceptable. So, as a…
-
Error Message: "Rows cannot be added to the destination sheet..." for my Copy Row Automation?
Hello All, How can we fix this error? The only change that was made was to the destination sheet and it was to change the owner from one person to another. Would that have anything to do with it? Here is the error in my workflow: Thanks! Ryan Holguin
-
Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
