-
Send Row - Filter Save
I utilize the Send Row feature on a daily basis. The majority of the time, the columns I select from the "Customize" section are the exact same. It would be awesome if I could create a filter and have the ability to select it as opposed to manually selecting all of the columns every time. Thanks
-
how to get a weighted average for a parent row, when children rows have "<" signs added to it
Hi there, I am currently working on a formula where the parent row will display the weighted average of children cells, based on the input weights. However, the problem I have at the moment is that there are numbers of cells with "<" sign added in front of the number and because of that, those data get ignored in the…
-
Countif a value AND Completed Date not Blank
Struggling with the right equation. Completed Date Column has no end range (rows can continue to be added at anytime via a form). Size Column has many different sizes 32, 40, 50, 60, 72, 80, 100, 106 that can be in the column. In additional columns I have a column for each size. I want to count how many size 32 I have IF…
-
Change font size when printing a sheet
I see posts from 2015 but no recent postings concerning changing the font size when printing a sheet. Is there a way to change the font size when printing? Depending upon the type of sheet and number of columns, the font is too small for the majority of readers to read comfortably.
-
Tracking incoming invoices
Hi - does anyone use Smartsheet to track incoming invoices? If so, do you have a template you would be willing to share? We want to record invoices when they come in and track on them before we forward them to our finance team for payment. Thanks!
-
Row Sharing Based on Contact Column
I just got an account and would love to send one link to lets say 75 people and they would only see the rows that pertain to them. I would accomplish this by adding contact information for all and make sure to create a contact column type and grant access based on that column. Does anyone know if something like this is…
-
Report Builder and Date sorting
I am trying to filter dates in report buider. I am using WHAT which gives me the option of manually inputting dates between . But when i use the run it doesnt filter to the date crieria I have used. I have tried to use the WHEN column but it I lose all the rows then and I cannot see the relevance of Modified or Created…
-
Connecting to Financial Management members
Is there a way to view the Financial Management members posts as a group?
-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
-
Count Blank Cells
Hi I am using Smartsheet for invoice approvals and would like to summarise how many documents are still awaiting approval. I have tried using a countif formula to count all cells that are blank in a certain column, however I get results that include lines are not used, e.g. there are 10 documents entered on separate lines…