-
%Complete to be automated
I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?
-
SUMIF
Hi all, I am trying to add a range of cells on condition that it does not contain any value that is equal to/or less than 0. for instance (12,45,24,0,65) should equal 0 and (12,24,24,10,65) give me 135. anyone to help?
-
Calculating Variances with Negative Numbers
How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%. IFERROR((Actual-Target)/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers. In…
-
Allocation in Template Sets
Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…
-
Is there a way to tell if a cell is used in another formula or not?
I have a sheet that I inherited and it has all kinds of fields used for statistic reporting. I want to edit the sheet, but don't know what formulas on this or other sheets I might break if I edit it. Is there a way to know if a cell is used in a formula somewhere else? Thanks, Carolyn
-
IF Statements and Linking Sheets by Ranges
Hi, I am working on a project creating a weekly sheet for distribution where one week of info is pulled from a range of data on a separate 13-week sheet. Basically, on the weekly sheet, I am using IF() statements to search a cell on the 13-week sheet for text. If the cell contains the proper text, the name from that row on…
-
Use a form to lookup sheet data that and add content to it
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
Counting criteria in two columns
I want to count how many times "Monday May 14, 2018 5:30-7:30 pm" show up in column A and how many times 1 show up in the same row in column B This is what I have but it is not working properly: =COUNTIFS([Date of Class]:[Date of Class], "Monday May 14, 2018 5:30-7:30 pm", replace:replace, "1") Thanks in advance
-
Numbers and Text in the Same row/Column
I have some writing that is not showing in a row/column when I have a formula to say so. Is there a way to get this to populate with both? Here is the formula that works: =IF([project name]14 = "", "", IF([PanAm proposal needed by]14 = "", JOIN("it's been ", TODAY() - [quote request by customer]14, " days"), IF([PanAm…
-
Impact with Urgency equals Priority
Hi, I am looking into utilizing a ITIL related priority matrix approach to populate a Priority. The Priority levels column's cell would have values P1, P2, P3, P4, P5. The formula needed in the Priority column would output an appropriate priority level based on specified combination of values from two other columns: Impact…