-
Hyperlinks do not work when sheet is exported
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 ?
-
Predecessor with Calendar Days on One Item
When invoicing, we use a NET30 policy where the payment is due in 30 calendar days. The remainder of our project timeline functions in working days (Monday - Friday). I want the "receive payment" step (line 31) in our timeline to be dependent on the "send invoice" step (line 62) and to appear in the tasks when the invoice…
-
Merged: Create report off of a sheet you are working live in
This discussion has been merged.
-
How do I create a IF(AND formula combining multiple cross references?
In this screenshot I am sharing my rollup data sheet. Of the 6 Total Amex CB Count, I am trying to determine how many of those each of our Branches has but I keep getting different errors using formula: =COUNTIFS({Dispute & Chargeback intake sheet branch}, CONTAINS([Data Points]32, @cell), IF(AND({Dispute & Chargeback…
-
What is the best way to move specific cell/column data when a specified trigger is met?
Customer example is that when information is added to the new order sheet, and marketing lead is assigned, and marketing deadline is populated, there are 5 columns of information that only need copied to the target sheet once the trigger is reached. The source sheet is 50+ columns. We don't want all columns. We've tried…
-
Error When Importing Google Sheet
I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!
-
Add Column to Row Report that was not in original sheet
Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. This column would have sensitive information in it that I do not want the other owners of the…
-
Toggle Option to for Sheet Viewing
Hi, I love the desktop app! My one issue with it is it always opens the very first sheet I ever opened in the app. It won't open the last sheet or open to the home page. I looked for a settings option, but there isn't any settings available. Please add a settings option for users to either open the last sheet they had open…
-
The $ Formula
A consultant I worked with was tasked with building a graph showing our portfolio growth over time. The graph needed to be a 12-month trailing horizontal axis which uses the (already recorded) dates for when any new project is triggered for provisioning. On the vertical axis, we wanted to track the sum of the project sizes…
-
Merged: Individually hide and unhide columns
This discussion has been merged.
