-
Multiple Columns for Calendar View and App
I am not aware of any way to pull in multiple columns into calendar view or within the calendar app. I think being able to do so would be beneficial as the only workaround that I have found is to create a report and embed multiple calendar views of the report into a dashboard to see all of the dates needed.
-
Should a non-licensed user that is shared as an admin be able to see and use Work Insights?
I am a licensed Enterprise user and have added some Work Insights to my sheets. The sheet is shared to a non-licensed user as an admin. They are not able to see the Work Insights button on the right of the sheet or see the summaries in the sheet. What do they need to do to be able to see the Work Insights? Are only…
-
How to Programatically Collapse All Through Smartsheet API
Hi, I have an automation that builds a smartsheet nightly but every time it does, it leaves everything expanded. I know how to collapse all in the UI. I want to do this step with automation so when the user hits the sheet, it's collapsed after a run. Reading the API documentation, I see you can do this on a per row basis.…
-
Programatically Collapse All Rows Through the API
Idea: A single command that can be used to collapse all in a smartsheet through the API. How is this done today? by running another script to identify each parent row and then send a command of expand=false. It certainly works but it's not clean or easy. A single command to collapse the entire sheet is needed. Why is this…
-
Print Generated Documents
Can we add the option to print a sheet after a document has been added? It would be setup that same was as "checking" a generated box which would trigger that document to be printed.
-
Better Sorting for Sheet Summary Report
If you have several dates listed in the sheet summary on a project, then you can have an option for those to be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of…
-
Formula Needed. - IF Blank, then Index another cell
Hi, I am looking for some help with a formula. I need a formula that will "pull/copy" the date entered in the column titled REV. START DATE. However, if the REV. START DATE is blank, then I need it to pull the date from the ORIGINAL START DATE column located on the same row. I was originally using the =MAX([Original Start…
-
Vlookup from two Sheets into one sheet
Good day, Im trying to do a Vlookup from two sheets into one cell. If the 1st sheet data is not a match, it will give an error, then I want the sheet to look at the different sheet for the needed data. Im trying something like this but getting a #UNPARSEABLE error =IFERROR(VLOOKUP([TRIP REF]@row, {Master Sheet - A Range…
-
Smartsheet Bridge: New Junction
Hi, I am exploring the "New Junction" in Bridge. When I add a value in Context using the dropdown, e.g. sys-animals, Bridge complains of unsupported module. Can someone please shed some insight into how the Context and Values To Check For can be used? Regards, AK
-
I am trying to get the last Monday of the month from a date using a formula.
I am working on a project where I want to use a formula to return the date of the last Monday in a month. For example, if I have a cell that says 4/11/2024, I want a formula that will then return 4/29/24 (because that is the final Monday of this month).