-
How can i create tabs in my Dashboard/Portal?
I watched the introductory video about Smartsheet on youtube and witnessed an amazing feature but I do not know how it was created. She had multiple tabs in her dashboard that functioned just like tabs on a web browser. Here is the link and time stamp of her using it. https://youtu.be/uGRFFavDm4Q?t=1524 . I have made…
-
How do you create a formula that calculates weeks out in certain cells based off one cells date?
Hello! I've tried to add a formula to convert an existing column into one with a formula and none are working. I have a target end date and i want existing cells in a "task section" to calculate the weeks out based off that date
-
Linking Google Slides & Smartsheet
I would love to see an enhanced feature, where Smartsheet and Google slides will integrate, and slides will auto-update. Any idea when this will be happening? Thank you!
-
Formula to determine is something is due this week
Hi all - I would like to calculate if something is due this week based on a target date in another cell. I have tried this formula: =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes") This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for. Is it possible to determine…
-
Date Formula: Calculate the number of days in a specific month between two dates
I'm working on a program tracker that includes revenue forecasting in each month. Project durations can range from one week to six months or more and I want the revenue to be forecasted evenly over the duration of the project. A date formula that calculates the number of days in a specific month between two dates would be…
-
URGENT! Account access terming! How to offload/archive data for access outside of Smartsheet
I urgently need your help! My employer recently sold my division and I just found out that we will be removed from the original enterprise account as of March 1st. I've built a complex toolkit based on the PMO Office template and use Control Center and Dynamic View add-ons. This toolkit contains data that is subject to…
-
Moving a project to another blueprint in Control Center
To setup Control Center Portfolio WorkApps, you have to start with a new blueprint. Short of having to re-spin up assets, it does not appear there is a way to transfer a project from one blueprint to another in Control Center. For Example - you have Blueprint x that pulls from Intake and outputs to Master Project List. To…
-
Lookup with #NO MATCH error
I've used the Lookup formula to find hours per work order number. Until today, the formula reported "0" in the event the lookup value was not found. As of either Jan. 17 or 18 (today), it now reports "#NO MATCH" when the lookup value is not found. Did something change recently with the way this formula works?
-
Card view sub tasks, can't see sub tasks of sub tasks
Card view is excellent, so good, was about to run my whole company of it!, however I have hit a snag – In card view you can view level one and its subtasks – good, however I now cannot see the subtask of a subtask, you cannot even see if there is another level below. Ok so you go to view all levels, which is fine but you…
