-
Why is there an edit limitation while you use WorkApps?
I put all the files I need into Workapps (sheets, report & dashboard), only to find out that not all the edit functions when you use right click are available. I was trying to cell link but only a hyperlink is available when you edit your sheets at Workapps. Thought it would more dynamic and efficient, but seems like I…
-
Why does the symbol font has fixed size?
I am trying to make my RYG symbol a larger size (in my sheet, report & dashoard) but even if I changed it from for example font size 10 to 28, there is no difference in how it looks like. Is there anyone who can help or might have experienced the same and share what you did? Appreciate the responses. Thank you.
-
Formula to check box if cell contains Date OR Text
I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to time (as a date is not always applicable to this particular field). How can I revise my…
-
INDEX/Match Error?
Hello, I have the following Equation written out: =INDEX({Brand Manager}, MATCH([Brand Channel]@row, {Brand Channel}), 0) {Brand Manager} and {Brand Channel} are pulling from Sheet A. Brand Channel is a column that is in Sheet A and Sheet B. The equation is written in Sheet B. My expectation of the equation was to pull in…
-
Merged: Checkbox column SUM summary in Reports
This discussion has been merged.
-
Formula to always Summarize all 5 cells to the right of a column, including new columns added.
Hi, Is there any formula that can return the summary of any of the 5 columns to the right of this column layout, no matter what columns are inserted from there on? I keep on adding columns, but I want it to always calculate the columns that are now (or in the future) within 5 columns to the right. Thank you,
-
Can you generate a date with limits?
I am working within a tracker, and I have the date autogenerating. Currently the date will generate once the first update will occur, and I just did =[Review Date]@row + 60 so that it adds 60 days from the review date. However, the program ends 12/31 so I want to add a limit so that if 60 days from the review date is after…
-
Approved Domain Sharing
Hi all, As an Admin I would like to run a report to establish what external users have been given access to our content. All external users have to be in the approved domain sharing list, however what are they accessing? Thanks Gavin
-
Dashboard Notifications
Hi, I set - up a dashboard recently for a client and would now like to automate updates to be sent to the client via email when changes are made to the dashboard. i.e. when a new link is added. Is this possible yet? I understand you can do this on sheets already. Thanks
-
% Complete Formula based on Start/Finish Dates
Hello! I am in need of help writing a formula to auto-calculate the "% Complete" column based on the "Start" column date and "Finish" column date. Additionally, I also have an auto column for "Duration". The goal is to have the % Complete auto calculate based on the today's date in relation to the start and finish date…