-
Dashboard on a Rollup Sheet
We have multiple projects in a sheet and created a rollup sheet to track all of these sheets. How do we create a dashboard on top of that sheet?
-
Resent Request for Approval
Is there a way to send a reminder to someone who received an automated request for approval? I have program chairs who are either not responding or are not responding in a timely manner, so the Approval Status remains "Requested". Right now, I reset the status so it triggers the automated request for approval again. It…
-
Sorting by percent complete
I originally created a report that showed all the sheets I was assigned to a specific task ans sorted by percent complete and then by sheet name. The sheets that had nothing in the percent complete used to appear at the top now they appear at the bottom. Without having to enter a 0 in every sheet that has not started the…
-
Linked Cell Format Issue
Hello everyone, I have tried looking for this topic, however, I can't seem to find anything. I have a source sheet with dollar amounts and the cells include a number such as $100,000.00. When I link the cell to a new sheet, the number shows up as 100000 Any idea how to fix this? Thank you. Sincerely, Diego
-
Resource View from more than one field.
As suggested by SS, I have a Assigned To field for a task lead (set for only one value allowed) and an Additional Resources field which allows more than one contact to be included. When I create a resource view, it seems like it is only pulling from the primary field and not the additional field. Anyone have a work around…
-
Cloudflare
Anyone else having issues with cloudflare when editing comments? Trying to fix some code i miss-submitted and can't change it. Basic stuff too, just missed some parenthesis.
-
If than statement
Hello, I need your help. I would like to use If statment in conjunction with symbols. The following is the statement that works only , got blank, green and yellow , but I cannot get it to work for red. =IF(ISBLANK([2019 Budget to Forecast Variance %]50), "", IF([2019 Budget to Forecast Variance %]50 <= 0, "Green",…
-
Automation Alert Someone Email subject
Hi all, Currently, when setting up an automated alert to someone, you can customize the message by entering the email subject/body. Right now, you can only enter free text in these fields. I was curious if you can set the email subject to fill in what was entered on an field on a form. I'll add a screenshot to clarify…
-
Attachment
I know on 26Aug19 brought the new Attachments in Right Panel logic. Question from a consistency perspective, is there plans to create this same look and feel in reports as well. At the moment, if you are in a Sheet, you see the new attachment logic, however, if you are in a Report, you see the old style attachment logic.
-
Multiple Selection on dropdown
Is the ability to select multiple items from a dropdown still in development???