-
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…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
Using COUNTIF to determine quantity of rows with number not ending is 000
Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchase order and have a hierarchy themselves. The numbers that are considered the parent end in 000 with all the items that are children end in various numbers in increments…
