-
Ranking when duplicates
I need help with a challenging formula. I have the following situation: Row# Value Score Effort Score Priority Score Rank* 1 50 5 45 4 2 70 10 60 1 3 65 5 60 2 4 60 20 40 5 5 70 25 45 3 If Priority Score = Value score - Effort score then rank by priority score (with greatest priority score = rank 1) if priority score is…
-
Dynamic view time-stamp issue
I am set up in CET, and I set up a dynamic view where the time stamp column (time created) in the sheet is transposed to the dynamic view with a +6 hrs. This is kind of inconvenient… is this an issue that can be resolved? e.g. 12:01 pm appears as 18:01 in the dynamic view vs. 12:01, 11:40 am appears as 17:40 in the dynamic…
-
Changes to license requirements for Editing
I have hundreds of hours in building sheets that link multiple teams. This was all done on the premise that we wouldn't need 100s of licenses for simple cell updates. All of a sudden I am getting bombarded by users saying they cant edit only to find out we now need licenses? I love the Smartsheet core product but this has…
-
Creating child rows with form selections
Newbie here! I have created a form for marketing requests. One of the drop down fields is for Marketing Avenues with 13 possible selections. I would love to find a way to auto create child rows for each avenue selected under the parent project row so we are able to assign those to different people and keep up with each…
-
Control Center Links and updating from report
I am using control center to create new projects and folders and linking to a Summary sheet. However I want to be able to create a report from the summary sheet and make updates to fields that will post back to the summary and the project. Is this possible? currently no matter what link option I use in the profile setup it…
-
Complete lack of support
I have been trying for 3 months to try to figure out why my RM Smartsheet integration with our ERP has stopped working. We know it's getting stopped on the RM side but no one from support will engage with me to resolve. I have been promised multiple times that "someone will work with me" but have yet to get any type of…
-
Help need by IF formula
Hi all, I need support by set up of a formula. The case is: - If column 'Team' = Security AND column 'T-shirt size hours' = L = 2 days THAN column Days_Sec = 2 - If column 'Team' = Development AND column 'T-shirt size hours' = L = 2 days THAN column Days_DEV = 2 - If column 'Team' = Basis AND column 'T-shirt size hours' =…
-
Embedding forms on a WordPress site
Hi, I am interested to hear of members experiences with the embed function of forms. I am using the latest version of WordPress and the embed code worked to post the form on a page, but now I cannot remove it to do further editing. I had a similar problem with Hubspot forms, so I suspect it is a WordPress issue more so…
-
Hello Everyone! About Me:
Hello everyone! My name is Kacie, and I currently work as a medical assistant. Recently, I’ve taken the lead on transitioning several of our projects into Smartsheet, and it’s been exciting to see how much more organized and efficient our workflows have become. I’m really looking forward to being part of this group,…
-
Report Filters Not Working
I have created a report and added the sheets from the workspace. I have created filters to pull in only the projects that need "approval to post." The conditions are set so the task that must be submitted before a project can be approved is submitted, and the task to approve the project to post is blank (not approved). I…