-
Como extraer la Hora de varias celdas
Buenas tardes, como podria extraer la hora de registro de 2 ó mas celdas?
-
Cell Linking
I have a inventory workspace. I am trying to set it up to link a cell on sheet a to a row on sheet b. The purpose is to set it up so that whenever the quantity on sheet A changes (no matter the cell), the quantity adjust on sheet B (for the entire row). Is this possible?
-
Formula not working - need help please - showing as incorrect argument
Can someone please help on the below formula - it is not working and showing as incorrect argument - I want it to take into consideration both the month and the year - if it past or later than the proposed service date then i want it to show its late via 'YES', blank if its blank and if its in date to show as N/A - the…
-
Formula history is now viewable in Cell History in table view
February 09, 2026 Users can now view the history of any formulas entered into a cell using the Cell History feature in table view (an improvement over the current grid view experience). Learn More Environments availability: Commercial US, Commercial EU, Commercial AU Plan availability: Pro, Business, Enterprise, Advanced…
-
How to count one name in a multiple contacts per cell column
I am trying to use the count function to counts names in a multi-contacts column and it is not working. Help! I need to count how many times each of my testers are assigned to an UAT.
-
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…
-
Isolate User Entered Value in Multi select list
I have a multi-select list that looks like the below. My goal is to map form results to a PDF and I've used helper columns to turn the responses into checkboxes [formula for those: =HAS([Indicate the type of referral source]@row, "Yes, parent")]. However….I do not have the multi-select limited to my answers so that staff…
-
Selecting the best Smartsheet for your project
I need to make sure I am selecting the correct smartsheet workspace for my project. I am trying to create a workspace to track and share client implementation. How do I add a Start date and then the sheet automatically adds task dates, as well as deadline, completion percent dates without having to add all manually. I seem…
-
Index/Match suddenly not working
Before I go down a rat hole, has anyone else noticed that an index/match suddenly not working? I have a sheet that's been working for a couple of years and as of this morning suddenly is showing NO MATCH where it was working yesterday. Thanks. /mrc
-
What is the best practice to manage adding features and changes to Smartsheet?
We are working on adding testing and change management to our Smartsheet instance. What are best practices for managing changes, and having a Dev to Test to Prod style workflow? How are others managing test data and automations that are not in production yet? We are working to add additional functions to our projects,…