Sign in to join the conversation:
I have a risks&Issues register sheet and would like to create a table in a new sheet which categorizes based on Streams and risk/issue rating. How do I do it.
Attached is the sample. I would like separate tables for risks & issues
Hi Sachana,
You can create a new sheet by clicking Home > Create New > Blank Sheet
Once your new sheet has been created, you can name columns and format the sheet as needed to make it into an issue log.
One suggestion is to use the same column names when possible for both your risk log and issue log, in case you want to create a report that aggregates them together in a single view.
You can also use an auto-number column for an "ID" column. More on auto-number columns can be found here: https://help.smartsheet.com/articles/1108408-auto-numbering-rows#create
Hello I could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.
