-
WBS numbering and work arounds
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 sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
Predecessor formula
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 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all be…
-
Problem with Index Match
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 pulling from On some it works however on other it defaults to the first one. In the 3rd Image I use the formula, =INDEX({Week…
-
Data accuracy
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 activity log within each sheet? Thanks, Amy
-
Auto update of "Custom Date Range" when scheduling a report?
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 the Custom Date Range update automatically? For example, "T " to "T+90"?
-
countif current month
I was counting for current month. However, I keep getting invalid data type. =COUNTIF({Month}, MONTH(@cell) = MONTH(TODAY()))
-
Training Plans - Central & Individual
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 individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
-
If Function with Checkbox
I think this is simple formula - but can’t figure it out. I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have. If checkbox 1, then take # from extended amount in same row and x1 in that cell. Does that make sense?
-
Template that automatically sends notifications to assignees on due dates
I'm trying to find an app that automates our processes — finance to training to sales. I want to create a template that I can that I use every time there is a new job to do. When training is booked for example, I want to create a new sheet, add the date of the training and have all the due dates automatically calculate. I…
-
sumif parent row
I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row =SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter}, =PARENT({Matter}@row) I keep getting an error in the formula