-
Time Since New
Hi Guys I have a column that shows when a ticket was created in Smartsheet. Now we just want a column that shows many hours have passed since the ticket was created. What formula do you use to show the number of hours passed since created? We have a Zapier zap hitting the sheet to wake it up every hour Thanks!
-
Find Corresponding Value (in Pieces) in Other Sheet
I have two sheets: Sheet 1 that people use to submit requests for course redevelopments and Sheet 2 that has a record of all 1,000 courses (with a link to the "master" in our learning management system). We are in the process of standardizing the names of our "masters". Essentially, they contain three pieces of…
-
Formula help - VLOOKUP from another sheet with deduction based on other criteria
Hello All, I am hoping someone can help me. I am trying to make an attendance sheet that will automatically deduct hours from the user's allotment based on manager approval and to also deduct from the correct type of hours (we have PTO hours and Vacation hours, each in different columns). I have a master sheet containing…
-
Formula for a Flag Column Based an If/Or statement
I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for Revised Analysis End Date). The flag should turn red when anything other than NA is selected. If NA is selected, then no red…
-
%Complete forumla reflective of sub tasks Complete
I am looking for a formula that will help me achieve a percentage complete column that will reflect the number of subtasks complete divided by the number of subtasks. For example: Parent folder with 3 subtasks Status of 1 subtask is complete Percentage complete column will reflect 33 percent complete Any help would be…
-
help with formula please
I have a percentage in a cell that has been derived by subtracting one percentage from another. ie 5% - 10% = -5% and I now want to represent this answer as a R A G coloured blob symbol, where: < -4.99% = G -5.00% to -9.99% = A > -10.00% = R Is thsi doable pls?...Thank you.
-
Identifying Duplication in a Column - New Form Submissions
Hello, I am trying to see if there is a formula I could use in a hidden column, with a checkbox, where when a new form is submitted (and a new line is then entered onto a sheet) it would alert me if there was a duplication in a certain column. Example: We enter new sales orders into Smartsheets using a form. If an order…
-
Formula for multi-cell status update
Hi all - First Discussion here. I am trying to use a formula that will populate a cell with "Not Started", "In Progress" or "Completed" based on the condition of eight cells in the same row have data in them or not.I have created two formulas that work in part but cannot figure out how to properly combine them.The idea is…
-
How to create totals for different columns for a specific date range
Hi I am struggling to get the total for all the columns in my sheet for each week Monday- Sunday. My entries are created via webform. I need to take into consideration the created date for my weekly time range Could somebody help me please? Thank you :)
-
Sum if formula based on condition in another cell
Looking for help on a formula! I want to sum the Forecast Amount values where the Sales Stage is equal to the value in the Status column. So for example, Status11 is equal to 2 - Qualification. I want the amount in Forcast Amount10 to be the sum of all the instances in the data below where the Sales Stage is equal to 2 -…
