Jerexify
Jerexify
Discussions
- OK, so I have two columns on multiple sheets, ESTIMATED PROJECT SIZE and ACTUAL PROJECT SIZE. On the sheet I'm working in, I have a column called PROJECT SIZE DIFFERENCE. Essentially, I want to write …
- So, this is a doozy. I am trying to create one report that, when one piece of information is entered, pulls the rest of the necessary information from across five other sheets. I have seen a discussio…
- Is it possible to have a formula that includes IFERROR, NETWORKDAYS, and MATCH? I'm working with two different sheets, both of which have a start date and an end date column, along with a project ID c…
- Good afternoon, I'm working with a sheet where the data is imported from Excel, and the Date column is actually the primary column on the Smartsheet tracker. Given that it's the primary, it's obviousl…
- Good morning. I'm having trouble conceptualizing a chart. I have several agents, and each agent has two data points for each month of the year. I need to put a chart together that shows both data poin…
- I am using this formula currently on a work document (slightly modified): =IFERROR(INDEX({Assigned Specialist}, MATCH([Project Name]@row, {Project Title}, 0)), "") Now, what I would like to add is a c…
- So, here's what I'm trying to do. I have three sheets in total I'm working with. All three sheets contain a unique identifying number for easy reference. Sheet A = Master sheet which is where the form…
- Good afternoon, I have two sheets I am working with, referenced here as Sheet A and Sheet B. Both sheets contain an identical column, which I will call "ID Number". Sheet A contains another column, wh…
