-
How do I make a Smartsheet that keeps track of initials
I'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many times people completed certain tasks.
-
Remove a dropdown option , if it is already selected
Surprised, this does not exist yet in smartsheet. I am creating a sheet , All I want to do is once a timeslot has been selected by a customer, the timeslot should no longer appear in the dropdown or hide it or make it un selectable. I am happy to explore the automation workflow option too, but there is no way to configure…
-
Enable Datalink from other Smartsheet for Dropdown list (for Multi and Single Selection)
Dear Sir/Madam, Kindly request you to add or enable datalink option in Dropdown list which helpful smartsheet users to update the Dropdown data in one place and utilize it all dropdown list. Thanks for prompt support. Best regards.
-
Send alert to task's assignee when predecessor task's status changes to complete
Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notification to auto-send to a task's assignee when the task's predecessor's status changes to "Complete"?
-
Turn Cell Formula into Column Formula
Hello everyone! I am at the beginning of making some operations sheets for my job and will need to rely on column formulas I have successfully input a formula in a cell and it works! When I drag the formula down, it works. However, when I try to convert it to a column formula I get the error saying that the syntax is not…
-
JIRA Sync To Smartsheets Not Syncing
The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We have to go into this workflow manually, edit it, then let it run every day. This is NOT automatic syncing like its intended…
-
Reference Sheet CountIfs Formula
Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula is: =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", Status:Status, "Open", Project:Project, "Data Analytics &…
-
COUNTIFS
I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
-
Dynamic Production Date Schedule
I work for a small company who manufactures kitchens in Oxfordshire. We are able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete. As there are many external factors that can delay or bring forward the manufacturing dates, there are many occasions…
-
Need some suggestions with highlighting info on a tracker
Hello everyone, I am looking for some creative support with a sheet that compiles milestones and dates from other trackers to an aggregated sheet with linked cells. The purpose is to share dates/milestones for each project with each column being a different project and the vertical axis being the milestone or deliverable…
