-
Formula -- If next 4 Columns say Yes/No say something
Hello, I have a sheet with six columns. They are: Name | Current Step | Step 1 | Step 2 | Step 3 | Step 4 Step 1 - 4 have Yes/No written in them for completion status. Can I have a formula in Current Step to count how many "Yes" there are and print the Step? Can someone direct me to where I can find out how to code this? I…
-
Countif using Dates and another Range
I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT reply. Not sure what is wrong. Below is a copy of my Formula. =COUNTIF([Request Create…
-
Cross sheet sum if
I'm creating a sheet to record the use of agency/contracting staff across a site (once the proof of concept is done it'll be expanded to cover multiple sites), where entries will be added to the sheet below via form. The "within budget" column on the 1st sheet should be picking up any entry from the Month Total Spend (MTD)…
-
Dashboard icons appear oversized
Just logged into smartsheet and all dashboard icons appear oversized completely disrupting the functionality of shortcut widgets. This is the first time I've see this. Same issue on two computer and three different web browsers (IE, firefox, chrome). Anyone seen something like this before? Thanks, Mike
-
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(),…
