-
URL Query String with Dynamic Data Connected to QR Code?
I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
-
How to send an automation to multiple contacts in another sheet?
Sheet A has a column of email addresses, the quantity of which is always unknown (could be 5 rows today, 10 rows tomorrow) and the content is not always static as people change roles (email x may be changed to email y tomorrow). Sheet B has an automation to request an update when a row is updated. How does Sheet B sent the…
-
Formula issue
This discussion was created from comments split from: Formula won't recognize cell data.
-
Expiration Date and Symbol Formula
I am looking for some help on a formula. I would like for if ANY of the dates are expired, put 'No' (red circle) in the row; if ALL of the dates are not expired, put 'Yes' (green circle) in the row. Below is a snip where I have entered the symbols manually to show what I am after. Is this possible?
-
Health Status Formula
I need some help with writing a formula to provide health status based on 2 dates as follows: "Estimated Completion Date" is greater than today and "Actual Completion Date" is blank - Blue "Estimated Completion Date" is less than today and "Actual Completion Date" is blank - Red "Actual Completion Date" is <=> today - Grey…
-
NEW! Dashboard center alignment and mailto links!
Hi Community! We’ve released two new enhancements that should make your dashboard editing life a little easier. Dashboard center alignment: You can now center align your widgets against the dashboard canvas itself so you know where the exact middle of your dashboard is when positioning a widget. Mailto links: Any email…
-
Collapse / Expand All to Sheet Picker
I couldn't find an existing topic in Community - When selecting a Report for widgets, it's unwieldly to scroll past the folder system. It would be an immense improvement to collapse folders and only see workspaces within the sheet picker.
-
In need of human brain to resolve AI formula.
I have a text column that says the following: 09/2022 I would like to turn this into a date for the last day of the month, like this: 09/30/2022 This is what the AI generated formula gave me: =DATE(YEAR(VALUE([Delayed Result Date]@row)), MONTH(VALUE([Delayed Result Date]@row)) + 1, 0) I'm getting a #INVALID VALUE error The…
-
If, Then with a date and N/A
Hello, I'm attempting to put 3-4 arguments together. I can get 3 to work, but not the 4th. I have 3 columns: Letter Due, Letter Sent, and Sent in Window. The Yes, No, N/A are calculated for Sent in Window using the below formula =IF(AND(ISDATE([*Confirmation Letter Due*]@row), ISDATE([*Confirmation Letter Sent*]@row),…
-
Critical path viewed when linked to a parent row
It would be nice to have the critical path show when linked to a parent row. I have a parent row (e.g. Testing) where the children (e.g. test 1, test 2, test 3,...) are performed in parallel & have the same finish date, so I often link the successor task(s) to the one parent row vs. each individual test task rows (can be…