Mohammed Sulaiman
Mohammed Sulaiman
Reactions
Discussions
- Hyperlinks for sheets do not work, when the sheet is exported to a pdf. However it does work when exported to excel. Any reason for this ?
- In the below schedule of values, the $ value of each child task is the parent value multiplied by a weight. For forecasting purposes, let us assume that 25th of every month, each line item is billed d…
- I'm trying to automatically calculate the expected % of both a task, and its sub tasks. Then compare it with the actual % complete entered manually by a user, and return status. The formula I have use…
- I have dates from two columns, Expected % Complete, and % Complete which I want to use, and populate the Status Column (Dropdown) using Formulas: The Dropdown options are " Not Started", "Behind", "On…
- Hi, I'm trying to use the formulas both INDEX and MATCH, and trying to pull the budgeted revenue, by comparing the two project numbers in the sheets and returning the corresponding value. See below fo…
- I'm trying to populate a column "Risk Impact", based on values from the column : Severity and Likelihood. The values are as follows: Value should be Medium When : Very Unlikely vs Minor Unlikely vs Si…
- I had received an email saying that the limit to cross-sheet referred cells in a sheet have been increased to 100,000. However, when I use formulas such as COUNTIF, etc with the reference range from a…
- I'm trying to create Line Chart widget on a Dashboard, to automatically update itself as the rows are added into the source sheet. How this was set up: In the original data sheet, the actual and expec…
- I'm trying to create a trend indicator (Down, Sideways, Up) from a sheet, which has columns - Created Date "Tasks", "Expected % Complete"," Complete %", and a helper column "% Complete %/Expected % Co…
- I have a report called "My Tasks" in my workspace, I also have a shortcut to this report in my Dashboard. When I click the report from the Dashboard shortcut, the view is different from when clicked t…
