4

Hello, does anyone have a solution for the excel / google function “PERCENTRANK()” or the “RANK” function.  We want to consolidate our roadmap planning into Smartsheets and use one of these functions to automatically score from 1 to 10 each item in the list.  The below image shows how this is done

4

Hi everyone,

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

3

I'm not sure what the best work flow is for this but here is my current setup:

  • I have a task list with all tasks for the duration of a project. 
  • I have reports that list all tasks due within the next day or week for the "current user"
  • Currently users get alerts for every task that is due on that day

5

I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. 

I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form?  I