-
summing up data for multiple people with text data?? and no Sheet Summary function
Hello, I'm hoping someone will be able to help me, I'm a Government user so I don't have access to all the functions that a regular user of Smartsheets would have, like Sheet Summary. So i may not be able to do what I am wanting to do, or i just can't think of how to do it. My team has a simple task tracker where we track…
-
Calculating Average Time for each member of a team
Hi everyone, I am new to SmartSheets and Excel formulas in general and would like some help please. I would like to calculate the average time in months that it takes for a team member to complete tasks. For example, I have a date created column for every task and another column named "Team member". I would like to…
-
Countif of children cells
Hello everyone! I got stuck on a formula that I need as KPI to monitor a project. I need a formula similar to the one that appears by default and that shows the percentage of completed task per macro level. In my case, I need it also for the other activity statuses, such as in progress and not started, so that in the end…
-
Subtract minutes from Hours
Greetings, I'm trying to subtract minutes from a set number of hours and display the amount of time left in HH:SS. For Example: There are 10 hours available for testing but totally the environment came up 35 minutes late. I know it is something simple but I'm missing it.
-
Quick Formula Help
Hi Community, I'm working with a colleague to create a column formula with multiple IF conditions. Just struggling to get our initial chain going before adding in others. What we need: -We have a column entitled "Submission Type" that contains a dropdown list of different submissions. Each submission has an estimated…
-
Voting using Symbols Formula
I want to collect "votes" from multiple voters (columns Voter 1, Voter 2, Voter 3, Voter 4, Voter 5, Voter 6) using RYG Balls in a sheet. Each row represents an item that is received through a form that must be voted on. I have a "Tally Vote" column that I want to use as a summary of sorts to reflect status at a glance in…
-
Get the value with the latest Date
Hi Experts, I need help in getting the value from the item column of Test Sheet1 which has the latest date and put it in the test sheet 2. I am trying to use, join(collect(Item sheet1 , Date, max(Date(@cell)) but not working. Can you help me with the correct formula? And second question, what if I have 2 reference sheet…
-
Using CountIf to get values from multiple sheets
Hi Smarties, Just out of curiosity, is there a simpler formula when consolidating data from multiple sheets with the same column name? For example, I have sheets Test 2 and Test 3. Both have status columns and I would like to count how many In Progress in my roll-up sheet. It works when I do the following formula…
-
How do I count how many projects are "In Progress" or "Completed" ?
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress Cancelled Completed How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled" Ideally this will…
-
Display date and time in India time from GMT
Assuming Created time is captured inGMT datetime, I would like to display Indian standard time in another column. I referend few timezone conversion samples, but its not working if the timezone time with excess of 30 min. India timezone is 5 hrs 30 min ahead of GMT, formulas discussed in the forum works if GMT+5 and not…