-
How to Use SUMIF Function for Sheet Summary
Hello! I am trying to use smartsheet to support budget tracking. I'd like to summarize the amount spent and section by our spend category. So if my Cost Center Category is equal to "Paid Media" I would like a sum of all rows meeting this criteria. So my range headings are Cost Center Category and Amount, my Criterion is…
-
is it possible to index a column from a different sheet if you dont have a value to match it with?
im trying to work around the 500 cell linking limit, which makes a lot of manual effort. i would appreciate any help.
-
Adding "Created by" column is auto populating every row with my name
I have a Risk Register with about two dozen rows of data. I want to add a "created by" column, so I can track who is entering risks. But when add the column and save, my name is appearing is all the rows as if I entered all the risks, which I have not. I'm thinking there is no way around this, is there?
-
Totaling a column
How can I get Smartsheet to total up the cells in a column that are not blank?
-
Is there a way to change a status cell based on multiple date criteria?
I am looking for help get the below equation to behave like I want. Currently it gives me #INVALID OPERATION, which I have trouble shot and determined it is giving me this because it is trying to perform logical operations on null values. The formula works if I populate all of the below date columns, but that isn’t how the…
-
Help Searching Mutiple Job#
I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project. I want to be able to do it for multiple Job…
-
Need to format part of a text string as a %
Ok, friends, here is what I have today... This part is working fine... creating my 'concatenate' cell. This is working fine, too... calculating my percentage... HERE is where I'm stuck... I have a JOIN / SUBSTITUTE function to bring them together, but... The 35% in the 'Calculation' column is coming out as "0.35135." What…
-
COUNTIFS with OR
Hello, I have spent hours trying to figure out what I am doing wrong, but I cannot seem to figure out what would get this formula to work. I am trying to count if my Simulation column says Phillips, the complete checkbox is checked and Type is Pilot OR Simulation. The formula works fine up until I add in the Type being…
-
Total Site % Complete + health
I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s say, Milestone ABCDEF etc I just want to SUM all the milestone % complete to give me the total project % complete Then the…
-
TOTAL% COLUMN
