-
Merged: Copying specific columns via automation
This discussion has been merged.
-
Smartsheet Integration with PowerPoint Office Timeline Pro+ Error
I keep receiving the below error when I try to Integrate my Smartsheet with Office Timeline Pro +. Anyone have a solution to this?
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Can I create a form that can automatically update a worksheet.
Hi there! I’m sorry, but I’m very new to this platform and still trying to understand how it works. My employer has assigned me a task to improve the use and functionality of our worksheets. He suggested that I explore the possibility of creating a generic form that can automatically populate client worksheets. The…
-
Rounding to nearest Thursday in the past or current day if it's Thursday
Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the current Thursday, if today is Thursday. In other words, the date should always display a Thursday date; if today == Thursday,…
-
Need a conditional SUMIFS formula
Hello, I have 2 grids Grid A: Project Management (used for team planning and communication) Screenshot of Grid A Grid B: Invoicing sheet (used for billing clients). I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is…
-
Dashboard Widget Dividers
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.
-
CONTAINS formula not working
I am trying to count the number of times the number "1" appears in a range using CONTAINS formula. There can be multiples numbers within the same cell seperated by comma. I have tried doing it via a dropdownlist too but its not working. Hoping for someone to help. Thanks
-
Allowing the Lag days in the predecessor field to be elapsed days
I've run into this issue where by the days I want a task to lag by is an elapsed number. E.g. Predecessor 380FS + e90d. The elapsed day function works well in the duration field.
-
Add Grouping to Report Exports
When exporting a Report to PDF or Excel from Smartsheet, grouping and summary rows should be included. As I utilize a lot of automated reporting, via PDF, this would create consistency in the report view and exported view.
