Sorry if this has been asked somewhere else.I am new to SmartSheet and have had a look in community but couldn't find an answer.
I have a Kanban board setup in SmartSheet and have a few reports running that are displayed within a dashboard
Currently I have a report that pulls all items and orders by
I have a Request Management sheet with a Form that we used to track tasks. They template came with a Metric sheet that is very useful. One of the metrics on this Metrics sheets counts items by assigned person. I want to update that to count only items that are not Closed status. Current formula
I need to add up the following:
1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function.
2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well).
I've searched through the community but couldn't find the right solution.
I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled
Hoping someone can help me, I keep getting a "#No Match" error for my formula. I have a neighboring column with top 5 orders and I am wanting to mirror the date that these top 5 occurrences happened (using a date column that already exists in my sheet). My formula is,
I am looking for the best way to create a document tracking checklist that tracks all necessary documents in our loan origination process for EACH applicant that may be on the loan. There could be 1 applicant or there could be 5. We could have individuals or entitys on the loans as well. I
What types, if any, of external input from other programs is SmartSheet capable of handling/using?
IE, is there a way to set up a sheet so that whenever a certain program updates its information your sheet does as well? If so, what types of programs function in this way with SmartSheet? Is it