Sorry if this is a duplicate. I couldn't find an answer that fit my problem.. Formula: =SUMIFS({AccHours}, {ShipDate}, <=Date3, {completed}, <>"x") All references are from another sheet except Date3. …
Hello Smartsheet Friends, I have a single text box that I'd like to do some data analysis on, and wondering if there is a way. My text box is similar to the below "Product, Engineering, IT, Supply Cha…
Hello everyone! I'm a project coordinator at a company specialized in manufacturing and installing irrigation systems, we have over 50 projects going on at the same time. We're trying Smartsheet to ch…
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the shee…
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 po…
Hi I'm trying to fill out the hours with Index/Match. It works with some but not with other. Here is the formula I'm using =INDEX({Week 19}, MATCH(Matter2, {Matter}) (Image 1) Image 2 - Were data is p…
I am working on a way to verify if data in all my sheets (about 10) is accurate, however, the trouble I am running into is the data is frequently updated. Is there a way to run a report that is like a…
I'd like to schedule a report each month to automatically cover the next 90 days. But it looks like I'd have to update the "Custom Date Range" each time for the next 90 days. Is there a way to have th…
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each indiv…
