-
OneNote integration in Smartsheet
Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/section group in one click, and then designate whether to open in the OneNote desktop…
-
Countif This Month, Next Month, Following Month
Heyo, I am trying to redo a formula to auto update with the information that I am currently pulling monthly for a dashboard. I am trying to sum the total fee installed if scheduled to complete this month, next month, and the following month. Here are the formulas I am using: This Month: =SUMIF({ECD}, IF(ISDATE(@cell),…
-
Keyboard shortcut indent after CTRL+K went away
Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyboard ( ] = AltGr 9) Ctrl AltGr 9 just types the symbol ]. Anyone else struggling with…
-
Viewing team capacity over time
I am trying to see my team's capacity over multiple projects for each week to see who will have capacity to take on new projects. In the past I've done it by hand to look like this and I know in my mind the demands of each phase for a given project. This is quickly becoming unsustainable as we grow. I have a task list for…
-
Baseline vs Target Dates
Hi, In the PMO template we have both baseline and target dates. What is the difference between these? The target date seems redundant. Thanks
-
Hyperlink in a Request Update form
I am looking to see how I can insert a Hyperlink into a Request Update notification, Please find the attached screenshot.
-
PMO Efficiency - Workspaces and Automated Backups
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…
-
Is there a way to move a dependant date further out without using lag?
I have a background of using MS Project where 'predecessors' are the equivalent of 'dependencies'. I have got used to smartsheets pretty quickly and for the most part get along with it but feel that there is a definite limitation when using dependencies as follows: In MS project if I have line 1 completing 28/11/23, I can…
-
Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty. I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells instead…
