-
Trying to identify cells in ALL CAPS vs Title Caps
I have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they can be corrected - is this possible?
-
Project Schedule Baseline - Is History Kept when Re-baselined?
We are using the Project Schedule Baseline functionality, but recently learned that the Schedule can be Reset or Removed. Is there anyway to track how many times a Schedule has been 'Reset' or 'Removed' and baselined again? Our concern is that without the history being tracked on how many times it's been reset, we won't…
-
Formulas Question - Referencing Another Sheet
Good morning, I am trying to pull calculate an average from data being pulled from another sheet. I want to be able to calculate the average duration, by month of completed projects. I basically want to say what is the average of the duration fields if the phase is completed and the end date column is in the month of…
-
Using CountIfs to track a column will multiple options
Hi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts all instances? Formula below for example =COUNTIFS({Training Project Task List Range…
-
Can I populate Smartsheet rows from a SQL Database read?
I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
-
Counting number of times a deadline is missed
I need a formula for a sheet summary that I just cant wrap my head around, might even be two formulas working together...Maybe I am over thinking it. I need a formula to look at a "date1" column and a "date2" column on a sheet and then I need it to count the number of times the difference between those two dates is more…
-
Equation to populate new number
Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last column is how much quantity that person claimed (Quantity Claimed). So for example, if…
-
Auto fill cells based on multiple criteria, using Index Match
I'm struggling with the logic here so any help is appreciated. My team manages new hires and we have to rate their performance weekly to report back to the new hires respective manager. Our program is 10 weeks long and to consistently rate them on the same metrics week to week, we created a survey that the trainers would…
-
Error in adding smartsheet as data source in tableau server
Hi All I am trying to publish a sheet to the tableau server so other people in my team can connect using the tableau desktop by logging into our tableau server. I was able to publish the sheet to the server as a data source, but am unable to connect to it again using the tableau desktop The steps I followed are 1.) logged…
