-
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…
-
Smartsheet still not working right after today's outage
I'm trying to demo a new Smartsheet solution I just built, but form submissions are taking at least 10 minutes to reach the sheet and trigger any automations. Smartsheet status says everything is fine, but I can't even access the Smartsheet support portal from my account! How can I make the support team away of this?…
-
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!
-
How do I get a hold of customer service?
I opened a case 10 days ago and have not been contacted nor has my issue been resolved.
-
How Do I Contact the Smartsheet Support Team?
Hi Team We are using Smartsheet in our Organisation and urgently need assistance with some formulas which are giving us issues. I am not sure who to contact please, can someone assist me? Thanks so much Benie
-
How long does it take for a support ticket to be addressed?
I submitted a ticket yesterday afternoon in the portal and it still hasn't been addressed/actioned. What are typical ticket response times?
-
Help with a dynamic status column
Hi- I have a {{Status}} which is a drop down containing the follow options "Not Started", "In Process", and "Complete". I have 4 columns which are checkboxes. I would like the {{status}} to dynamically update based on the check boxes in the columns. If all the checkboxes@row = 0 then status would be "not started" but if…