- Tracking Assigned Tasks
Dears, How to view a specific person tasks on smartsheet, i assign multiple tasks for multiple users so what is the best way to keep informed or to check the update of a specific person tasks. Thanks.
- SUM Parent without Children?
I've been able to figure out how to SUM children under parents, but is there a way to SUM just the parent rows? For instance: NAME NUMBER Parent: 10,000 Child: 10 Child: 10 Parent: 10,000 Child: 10 SUM (Parent only): 20,000 I'd like to do this without selecting each cell if possible so it'll update whenever new Parent rows…
- Finding the most recent date for one person
I work at an University and we are trying out smartsheet for keeping a log of when instructors have taught. In one sheet I have a column for the start date of the course, the end date, the name of the course and the instructors name. I am wondering if there is a way to pull the most recent date that an instructor has…
- Calculating Durations
I have columns in my sheet with "Departure TIme" and "Arrival Time" in the format hh:mm Since there is no "Time" Type for the columns, so I had to kep the Column Type as Number/Text I am looking for a way to substract these 2 columns to obtain the duration of the trip. Many thanks for any help
- Formula to sum from different sheet
Can I do a forumla =sum(range of cells on a different sheet)?
- Créer une ligne de date réccurente
Bonjour, Je ne trouve pas le moyen pour faire une ligne avec des dates réccurentes (par exemple réunion tous les mardi à 15h ou tous les 1er mardi du mois). Merci de votre aide.
- Cell reference formula
How can I create a formula from two columns that will result in pulling in the value from a third column? Column1 (text) = Column4 Column2 (text) = 3 Column3 (date) = Column1 + Column2 Ideal Column3 result = [Column4]3 Please let me know if I can clarify anything, it is a little confusing. Thanks
- 多个公式s: Formula SUM conflicts with Formula IF Logic
I have a sheet set up so that when a checkbox is checked, the price of a product generates in the column next to it. I also want to be able to capture the sum of everything in the price column, but when I input an =SUM, it reads as 0.00. Is there a way for the formula to calculate the sum of values that are generated by a…
- Still Looking for an IF function that does nothing to the cell if False
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
- Confused by NETWORKDAYS results
I have a formula such as: =NETWORKDAYS([Planned Start]1, [Actual Start]1) When the Planned Start date is say 10/29/14, and the Actual Start date is 10/30/14, the result is 2. To me, the difference between those two dates is one day, not two. I don't have any holidays set for these dates, and I've tried wrapping Actual…
