-
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
-
How to retain monthly calculated counts of projects in certain statuses?
We need a way to provide counts of projects in various statuses each month through a calendar year; for example...how many projects were in progress in the month of Jan, how many projects were completed in the month of Feb, etc. I have a column for each month in a calendar year and rows representing the metrics we need to…