-
Check the Checkbox on multiple lines together
Hello everyone I would like to know if it is possible Check the Checkbox on multiple lines together
-
Link Data in a Smartsheet on a Specific Day and Make Static
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links data from the %Complete metric on a given day, and make that data static in the new…
-
Plotting cost over time
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months. I am pretty sure each cost would need to be broken down into…
-
Adding resources cost
Hi all, I'm fairly new to smartsheet, and i wanted to know how do i use the "bill rate", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs to my resources and I couldn't find the best practices for that. Would love to hear any tips and recommendation. Thanks,…
-
Help with SUMIFS formula to display todays census
Hello, Every day three service line VPs complete a SS Form. The form's information indicates todays date, service line, and a census. I need a formula (I presume =SUMIFS) that tells me the census for one of those service lines for only 'today's date'. That sum then flows to a dashboard widget so leadership can view only…
-
Resource Management info in a dashboard
Hello, I am creating a dashboard and I need to add a resource view to it, to show the resources assigned to a specific project. Is there any way to do this? Also in the resource view, is it possible to limit the projects considered to calculate the allocation? I have some backup sheets and Smartsheet is taking also the…
-
Incremental Budget Forecasting based on Monthly Due Date Percentages
In excel, we have two sheets: Sheet 1 - A percentage breakdown per country based on historical data for each Month prior or after the Due Date month. Zero = Month Due Date. -1 = the Month prior to the Due Date Month, etc. Sheet 2 - For Country, Due Date and Projected Total Spend, we calculate (via formulas) the Current…
-
How do I find a smartsheet expert for hire to help build out our workspace?
Hello all, I am looking for a smartsheet expert, who can build a project template for us, including a dashboard for internal and external use. We are based in The Netherlands, but we can manage everything in English as well. So are you / or do you know an English speaking smartsheet expert, who we can hire for support and…
-
Nested IF with Children
Greetings, I'm attempting to configure an Epic (parent) field to automatically change based on the statuses of the child fields. For example, the criteria I'm attempting to meet is: If all child status fields are in "To Do" then parent field status is "To Do" else "In Progress" If all child status fields are in "Done" Then…
-
Rolling 2 week task count
Hello, I am trying to do a cross sheet formula that counts the number of tasks that are not complete and have a due date in the next 14 days for a specific department. I hope I am close but it is coming back as unparseable. Could someone please review and tell me where my mistake is? Please find my formula below.…
