-
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…
-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Using INDEX MATCH Function with a Multi-Select drop-down column
Hello, I am trying to use an INDEX MATCH function to fill in the Transmission Region for the Sites Under Consideration, but am running into a problem when there is more than one site selected. I believe I need to add the HAS function, but have tried several ways and can't seem to make it work. Any help is appreciated!
-
Submitter (Created By) Showing as Web-Form
Hi -- we have a sheet we are using by sending the link to the form to all employees. They manually enter their email address in the form. The issue is when the form is submitted the workflow automation doesn't work because created by is a web-form. The email from the email address column that was entered by the employee is…
