-
If and if/and statement
I'm trying to do an if statement for if a cell is blank to leave it blank and if not to perform an if/and statement. I did it in Excel but when I imported the file into Smartsheet it wasn’t working. So I’m trying to write it in Smartsheet. I did get it to work at one point but the acceptable and review responses were…
-
Formula for summarized health indicators for discrete categories
Hello, Perhaps this has been answered elsewhere - in which case I appreciate being redirected. I am trying to determine if it is possible to create formulae that summarizes a health indicator symbol (Red, Yellow, Green) across multiple rows in a sheet, when further categorized by a variable in another column. So, in other…
-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Formula Help Please!
Hi Community- I have a column that I want to say what phase a project is in based upon the criteria below 4 Possible Phases – “Strategy & Intake”, “Brief Finalization”, “Detailed Concepts”, “Production to Market” #1 “Strategy & Intake” – Milestone “BRIEF COMPLETED & APPROVED” is not checked and is not in the next 21 days…
-
Vlookup and matching
Good morning, First time using a Vlookup formula. All I am trying to do is cross reference employee numbers from one sheet to another. If the employee number exists in sheet A and is a match on sheet B, I want it to flag. I think I am over thinking it, Any help would be appreciated. In the screenshot, the formula will…
-
Calculating the Number of Tickets Opened
Hi There, I am currently building a Dashboard and I want to show the number of Tickets that have been opened for a certain period, e.g. the number of tickets opened with a week. Is there a formula that I can use to achieve this.
-
Circular Reference / In Excel it works / SOLVED
This has been solved now :) Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. Saves some 30+people now a lot of work. Hi there, we are stuck transforming some sheets…
-
Auto-fill an overwrite-able value
Hi Community, I have a worksheet with a column (let's call it "FPD Factor") for calculating how many files can be scanned per day by a process. I would like for every new record created to have that column auto-populated with "70,000", but want it to be overwrite-able by someone. I plan to use the FPD Factor value in a…
-
De-Scoping/Deactivating Rows
We need a function where users can de-scope rows, thus deactivating that row and removing its influence on its parent rows. Is that an option via Smartsheet?
-
countifs formula help
I am trying to Count # of tasks if the task meets multiple criteria. For example, the task is green, it happened in the 2 quarter and it's in the metrics workstream. I get an Invalid Ref error in the formula. I am only counting tasks from the same sheet. Formula is below: =COUNTIFS({Health}, "Red", {Quarter}, "Q2",…