-
How to tell if Multiple Invoices have all been processed
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Counting for a Blank Cell
Hello! I have this formula that works great: =DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3))) But if my date in "[Completion Date]3" is blank it throws off my whole formula. What can I add so it stays blank if I have no date in "[Completion Date]3". THANK YOU!
-
Error while uploading attachments
When i try to upload files to the smart sheet , any mail attachments or documents. I'm getting an error message and it doesn't allow me to upload the attachment.I have attached the screenshot of the error message. please help me with the same.
-
IF formula mix AND & OR functions, dates on modified and created columns
I'm looking to add a formula which will check the dates in modified and created columns and update the status column. If the modified date is today and is greater than the created date I want to populate the Status column with "updated", but if the modified date is equal to today and if the created date is also equal to…
-
Stop Modified date updating for formula cell/column
Hi, I have a formula in place to have a certain value in a cell if the modified date is today "Updated", and if not display a different value "Not Updated". However, this seems to work when I open my sheet the next day the value is "Not Updated", but then the modified date updates after saving, because the formula has…
-
IFERROR
how can I add IFERROR to this formula =WORKDAY([Start Date]140, 15) I tried =IFERROR(WORKDAY([Start Date]140, 15, "")) and it didnt work
-
Dark Mode feature need
How can we get a dark mode feature into the pipeline? It's very common these days for reports and forms to throttle between regular and dark mode. Hope this can be done easily to stay up to date.
-
Metric Widget Column Header
I am trying to grab data from my dashboard metrics sheet in such a way that data is associated with the selected column header, as opposed to the actual column header. I am trying to use the Metric Widget like how I use the Chart Widget, but am getting results like in the screenshot, attached, where the heading I am…
-
Building a Dashboard from a Report
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build a metric sheet to create my Dash based upon that report?
-
Send Update Request Flag Does Not Appear in Reports
Hi Rather than sharing an entire sheet, I have created reports that allow someone to see part of the data that is relevant to them. Some of the rows have send update requests on them. I cannot see this in the report and there is no option to show this. Having this will make it much easier for the person to see what is…
