-
Can I change the font size or move the labels for individual pie slices of a pie chart
Currently showing a pie chart which has each pie showing 1,000,000 5,000,000 ; 7,000,000 size numbers. Can I move the labels around like in MS Office charts to minimize the overlap of numbers and make it look neater and cleaner
-
How to show scope versus capacity per month using date ranges?
Hello! I have a dashboard that is currently showing values like Estimate in Days versus Allocation in Days to show the scope of the work versus the actual days a person is assigned to the work (i.e. Scope in Days versus Actual Allocation in Days). I have this working to show scope versus capacity per fiscal quarter but now…
-
Checklist workflow automation
I'm trying to convert a onboarding checklist into an automated workflow. For example. Role X has tasks 1, 2, 3 associated with it. Role Y has tasks 1,2, 6,7 associated with it. I would like the tasks to auto-populate based on the role. It would also be great if I can notify people when it's time for them to work on their…
-
Inserting contact name based on dropdown menu choice
Hi folks (but especially @Andrée Starå 😁!), My next query is around inserting contacts based on drop-down choice. Certain departments will be attached to a task and once they are chosen, I would like a column to change to a relevant colleague contact. Again, I had a crack at an IF statement and got this far: = IF([Assigned…
-
weighted task %, % complete by time
Hi, I'm having trouble wrapping my head around how to produce a formula for my scenario. We are considering each task (hierarchy 1) a percentage of the overall project. For example, research is 5% of the project, production is 25%, etc. For simplicity sake, I would like to report % complete based off of time elapsed for…
-
Drop Down List Matching Formula
Hi, I have two columns and each column has a multi drop down box. I have been trying to create a formula that will return a date in a 3rd column when the first two columns drop down list match. Any assistance is appreciated.
-
Index/Collect with a date being one of the criteria
Hi, I'm trying to write an index/collect formula and one of the criteria is that the date is yesterday. I'm having trouble. Any suggestions? =INDEX(COLLECT({Evergreen Totals}, {Admission Type}, "Start of Business", {Date}, TODAY() - 1, 1)) Thank you!
-
Formula not working in Smartsheet when data is populated from form
I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form. Thank…
-
Question Using TODAY Formula
Good day, I have a basic question, is there a way to use the TODAY function in a formula that will run the calculation and update my sheet without having to open the sheet everyday to "trigger" the calculation? What I am getting at is I have a sheet that uses TODAY in many calculations, however, due to the size of the…
-
Generating dates based on dropdown choice in another cell
Hi everyone, I'm very new to this and trying to generate a formula that will calculate deadline dates based on dropdown choices in another cell. If we get customer queries by phone, we have a deadline of 2 days' resolution; if we get them by email, it's 10 days. I would like to be able to auto-generate deadline dates for…