-
Tracking a sum from separate column of specific values
Hello, First, I want to thank all of you for your help on this community. I'm learning a lot and this place has helped me out immensely. I've looked around and have found some similar questions, but I can't seem to get this to work, so I want to turn it over to y'all. So let me start with a snapshot of my sheet. What I…
-
Am unable to retrieve Dates from one smartsheet to other
While am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect Value
-
Workflow to Update Date to TODAY() until another cell = 100%
I 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 the % field = 100%? Thanks in advance!
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
Hard 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 of formula or function that would allow us to type an employees name in next to the…
-
Sheet Name within a Cell
Hello, 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 need to filter out within a report. Thanks, Anthony
-
Frozen/Unresponsive Sheets
We'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?
Hi 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 actions organized in rows based on the 50 items. Our goal is to have this sheet…
-
Dynamic Drop Down lists from another column either within the sheet or from another sheet
I'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, color, country, end customer I'f like osmeone to be able to select the category (call it…
-
Formula to add "No" to a blank cell, but leave value if not blank
On 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 for a formula to replace those blank cells with "Does Not Apply" but leave a value there…
-
Calculate the time between two dates by days, hours and minutes
Hi, 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" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…
