Cell linking
Discussion List
-
Workflow to Update Date to TODAY() until another cell = 100%In Formulas and FunctionsI have 2 cells in a column: Which displays a % from 1-100 Which should show a date Is it possible to use a workflow or other automation to daily (at 12:01am or any other time) update the date field to TODAY(), but to stop updating it once …
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?In Formulas and FunctionsHard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type…Answered - Pending Review 24 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Sheet Name within a CellIn Formulas and FunctionsHello, I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on? The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i n…
-
Frozen/Unresponsive SheetsIn Using SmartsheetWe're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks
-
Workaround for Sheet Reference Limit?In Using SmartsheetHi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel …
-
Dynamic Drop Down lists from another column either within the sheet or from another sheetIn Using SmartsheetI've searched, but everyone seems to say that this is not an option at the moment, are there any work arounds? I want to create a page where someone can create a product id number based on several factors, i.e. category, model number, colo…
-
Unwanted Default gray background of the dropdown selectionsIn Using SmartsheetHello, I am trying to change the backgound color of the Dropdown selections that appear in the cells to white. Is this possible? is there any CSS formatting i can give to the background of the dropdown selections? I would like that gray b…
-
Formula to add "No" to a blank cell, but leave value if not blankIn Formulas and FunctionsOn a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not like Blank cells, so I'm looking fo…
-
Calculate the time between two dates by days, hours and minutesIn Formulas and FunctionsHi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
-
INDEX/MATCH function doesn't return exact match.In Formulas and FunctionsI'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting f…Answered - Pending Review 85 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions