-
INDEX, MATCH, and OR Function
Hello, I am trying to use INDEX MATCH and the OR function. I'm referencing 3 other sheets try to say if we find x in any of these 3 sheets I want y from those sheets. x and y will only be present in 1 of the 3 other sheets. However every I do this I either get an error code or unparsable. These are a few of the formulas…
-
Starting
OK—After years of fortan and cobalt, I cannot even get started on Smartsheet. I am stupid. I loved the program Smartdraw and they ruined it. Yours looked great! I need simple instructions on how to start the process of building a chart or graph. Yes I get the detailed programed responses and ability to check with other…
-
How to auto populate cells
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
-
Software Onboarding, Risks assessments, budgets, and more
Hello, I would like a sheet that can track software onboarding from the beginning to update and all the way to end of life. I have an excel sheet that I converted to a smartsheet, but I feel it's a very one piece modifying any data. Seems that it should be a very simple process that I have a blueprint with smartsheets and…
-
How to analyze users that can be downgraded from Member to Contributor?
I am a new admin. How would I know who can be safely changed from Member to the new contributor role? Is there something or combination of items that can reviewed on Seat Type Report?
-
Portfolio Project List Sheet Summary
Hello! Week three of my Smartsheet journey in the consulting space, apologies if this is a very simple question. I have been tasked to get to know the new Portfolio section. When looking at the dashboard there is the high priority projects metric being fed by the sheet summary data from 'project list' sheet. This sheet…
-
Merged: Bulk Sheet/Report Share
This discussion has been merged.
-
How to show parent and child rows with filter on?
I believe I need a helper column but I have no clue how to start it. We have a filter set up and when we turn the filter on, we are not able to open the child rows. I have included screenshots. Thank you!
-
SUMIFS formula bringing back total of all items, not items in specified date range.
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
-
Sharing a Single Smartsheet with External Partners (No SSO Access)
Hi Smartsheet Community, I’m hoping you can help clarify a Smartsheet sharing question. I’m trying to share one specific sheet from my Smartsheet plan with two external colleagues from our partner organization. Several colleagues have mentioned they’ve successfully shared sheets with external partners before, so I’m hoping…