-
Monthly, 6 Monthly, 12 Monthly reporting
I'm currently working on a KPI structure for my organisation. An entry will be made each month via a Smartsheet form, and they'd like to know the latest entry, as well as the last 6 month and last 12 month totals. I'm struggling with how to calculate these. I assume that I'd use the max function along with a created date…
-
Cell contents into Text String
Hi, I'm trying to create a column that essentially mail merges within the cell by pulling from previous columns. For example: "[Name] is [Age] and attends [School Name] school." where the bracketed terms are columns in the sheet. Can I do this in Smartsheet or is it restricted to Excel so far? Thanks!
-
Populating Sheet Column Content from Report
We are using a unified Asset Tracking sheet in smartsheets for multiple types of Equipment (i.e. Phone, Computer, Printer, etc...). This sheet has basic Asset Tracking information in it but we need to gather additional equipment specific to each type of equipment as well. We could create a column for each in the Unified…
-
Task Status Formula help
I am trying to update the below status formula to update the "yellow" status to be determined by a % complete less than 25% and the Due Date (week of) is between 7 and 14 days in the future. Here is the current formula: =IF([% Complete]26 = 1, "Green", IF(AND([% Complete]26 <= 0.25, [Due Date (week of)]26 > TODAY()),…
-
hh:mm:ss Time Tracking in Smartsheets? (Probably not possible)
Howdy everyone! I've got a pernicious little problem that I'm wondering if anyone has any ideas about. My team and I currently track all of our break/fix help tickets in one dedicated "backlog" sheet. Each task that we need to complete is added to this sheet, gets prioritized, gets worked on, gets clarified (if needed),…
-
How to use All 4 Formulas together "IF AND NOT OR "
I have to create a formula that returns a value "1 or 0", so I use the IF statement. Now to satisfy multiple conditions, I am using the AND statement. Also, to I want to check if the statement is not true, Hence I use the NOT function. Based on this, the formula for my example is: =IF(AND([Actual Complete]6 < TODAY(),…
-
substitute plan date with actual date
Hello, Trying to create a formula that can substitute the plan date with actual date. There are columns of Plan Start/End, Actual Start/End on the sheet, and the actual start & end are initially left blank, and once a task is kicked off, the one assigned is supposed to fill in the actual start, which substitutes the…
-
Number of NetDays since last event
Hi, Looking to calculate the number of netdays since an event was recorded. I have a {Date of Incident} column and a {Classification} column Looking for the number of days since a specific classification was reported i.e. {Classification}, ="Lost Time Injury". Want to be able to report this as a Key Indicator of No. Days…
-
IF and VLOOKUP with multiple options
Trying to summarize from a worksheet to another (summary worksheet). The VLOOKUP should give an "X" if includes "August" and instead gives the same answer for every search since there are multiple of the original search; it's saying yes since it saw it the first time, but shouldn't if actually missing. Original worksheet…
-
% complete in a row
Hi, i am looking for some help. I have a project which has 360 locations, resulting in 360 rows. i have 8 status columns in each row. is there a formula that will replicate a % by counting each status column that is complete and making that =12.5 . So for example all 8 status are complete this = 100, 6 status complete…
