-
Is anyone else still having "random and intermittent" issues with cell links not working?
We have been having issues with cell links not updating since early October. Smartsheet support and pro-desk say they are working on it and then close our support tickets. Does anyone have any more information on this? We still have issues, but no one is talking to us.
-
Change Milestone Diamond Color
Hi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀
-
How can I add a number of days to a date column in the same sheet?
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
-
Finite Dropdrown values?
Hello I'm was wondering, if it's possible to make a list of dropdown values available. But every time one value is used, it's removed from the list of possible options for the following row. Number 1, 2, 3, 4, 5... If I then use number 1, it is not possible to select 1 for the next row. If I then use the number 4, it is…
-
The link out arrows have disappeared?!
I have two SmartSheets in use. One for my engineering team, and one for my construction team. I have hundreds of cells linking in and out of both sheets to one another. For some reason the cells which are sending the data (Linked Out) are not showing the little black/grey arrow within the cell, but the cells which are…
-
Unable to edit Blueprint in Control Center (I am Primary Lead)
Hi All, Hoping for some help that I have been unable to get from Smartsheet Support. I am the primary lead of our Blueprint, but when I go to edit the blue print I can get through the Blueprint Basics tab all the way to Profile Data Selection and then the site freezes up. While the Blueprint and provisioning work…
-
Formula to look at specific column/cell depending on the current month
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
-
What wrong with this IF OR Loop statement
=IF(OR([Site]@row= "Kelowna", [Site]@row="Vancouver", [Site]@row="Victoria"), "British Columbia", IF(OR([Site]@row= "Halifax", [Site]@row="Moncton", [Site]@row="St Johns", [Site]@row="Grand Montreal"), "Eastern", IF(OR[Site]@row= "Central", [Site]@row="Tannis", [Site]@row="SW Ontario", [Site]@row="Toronto") , "Ontario",…
-
Average Collect Issues
Hello! I'm trying to write a formula that will average the amount of time a type of request takes to complete by month. I'm referencing another sheet in this formula and just can't get it to work. Here's what I have so far: =AVG(COLLECT{Hours to Complete}, ISNUMBER(@cell), {Request Type}, "Quote Request", {Submitted Date},…
-
Will the 2023 Project Management Path eLearning earn PMI PDUs?
With the release of the 2023 Project Management Path eLearning I am curious if the course will provide PDUs for PMI Certifications such as PMP. If so, how many PDUs will be earned? Additionally, it mentions that the user must be core app certified prior to taking it. If you have the 2022 core app badge do you need to wait…
