Cell linking
Discussion List
-
How do I make a Smartsheet that keeps track of initialsIn Using SmartsheetI'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 …
-
Remove a dropdown option , if it is already selectedIn Formulas and FunctionsSurprised, 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…Answered - Pending Review 33 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Enable Datalink from other Smartsheet for Dropdown list (for Multi and Single Selection)In Using SmartsheetDear 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 completeIn Formulas and FunctionsHi 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 …
-
Turn Cell Formula into Column FormulaIn Formulas and FunctionsHello 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, wh…Answered - Pending Review 15 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
JIRA Sync To Smartsheets Not SyncingIn Using SmartsheetThe 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…
-
Reference Sheet CountIfs FormulaIn Formulas and FunctionsHi 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…Answered - Pending Review 48 views 4 comments 0 points Most recent by David Tutwiler Formulas and Functions
-
COUNTIFSIn Formulas and FunctionsI 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? ThanksAnswered - Pending Review 25 views 4 comments 0 points Most recent by lukasrobbo97 Formulas and Functions
-
Dynamic Production Date ScheduleIn Using SmartsheetI 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 t…
-
Need some suggestions with highlighting info on a trackerIn Using SmartsheetHello 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…