-
Pull data from Multiple sheets into single sheet and still allow to put formulas
Hi, I have different sheet for projects but I want some key specifics in a single sheet that could allow me to use this data later to present the billing and other related aspects of the work. Here's how it works: Project plan sheet: This contains the project plan, start dates, end dates and the %complete. For an instance…
-
If cell is empty or blank, I want to automatically enter a 0.
I'm not sure how to automatically enter a value of zero if a cell is empty. Is this possible? I tried to enter the formula below (and various iterations of it) but I get errors. The error for below was "unparseable". =IF([% Complete]1:[% Complete]17, ISBLANK, ("0")) Anyone know if this is possible? Thx, Deb
-
Is autofill possible in this scenario? and how
I am working on a calendar form and I would like if I entered a specific name of an event, that the next column would autofill a number. For example, if in the "event Name" column I type "Marathon", I would like the next column to autofill with 18000 for the expected participants. Is there a way to do this? Thanks
-
How to not skip ranks and deal with ties?
Hi all, I worked with the Prodesk on using the RANKEQ function which was helpful, but I am realizing I have records which are ties. Essentially I have a column which ranks our projects; if the weight is 0 it's "not ranked" and should be thrown out of the rankings, if it's anything else it's ranked. The formula is as…
-
If Statement with nested VLOOKUP formula
Hi! I would like to return a value from another SmartSheet if one column in that same SmartSheet has a "Y". I have the current formula below, but it's returning a #NO MATCH error... any thoughts? In summary: return value in column A of SmartSheet Y to SmartSheet X if coulumb B in SmartSheet Y = Yes.…
-
Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
-
Simple row multiplication formula
Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row. For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15% I am multiplying 1 row by a fixed number. I am not multiplying two rows together. What's the correct way to…
-
Simple sell date - buy date formula
Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf. Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column. What's…
-
% Formula
Hello, I am trying to calculate the % complete within the "Status" column. I have Task labeled "In progress" "Not Started" "Complete" and "N/A". I have Sum formulas set up to tell me how many are complete etc but am looking for a percentage. Any advice ?
-
Is it possible to get the reference of the First Parent ?
I would like to extract the sub-parts whose biggest Parent is called Media communications. Is there any function that allow us to extract the name of the biggest parent instead of the closer one ? =Parent(Example@row)