-
If = 0, return a Blank or ""
I'm using the below to count different types of calls we receive, by person, by month. If a person gets none of those calls in Jan for instance I want it to return a blank, not zero. I tried IFERROR as below but that did not work. Thanks! =COUNTIFS({2025 Call/Email Log Recipient}, ="Bob Flowers", {2025 Call/Email Log…
-
Index Match formula not working properly
I'm trying to use an Index Match formula to pull data from another sheet based on matching an order number (T Scan column). For some reason it works perfectly when the order number is 8 characters. Any order number less than 8 characters returns #NO MATCH. I even tried adding additional characters to one on this sheet as…
-
Bring back permission change settings from within the sheet
I was able to change the permissions to a sheet by hitting the Share button within the sheet. I am not able to do it anymore and I have to go to the workspace, select the item, click Share button and then I can change the permissions. Users are not really taking this change positively. Is there a possibility to bring this…
-
Web Content Widget Limitations
We use an online tool called Calendar Wiz and they have web integration plug in capability. However when I drop their code into the widget to include it on a dashboard I get he following error: Is this just not an application that is compatible for the widget? I can use a Shortcut widget, but would be more cumbersome and…
-
Recurring Meetings in Schedule
Hi, I am developing a project schedule and wish to include bi-weekly client meetings. Is there a way that a task can be shown as recurring on a schedule? Ideally this would show in a single row. Thanks
-
Rounding as a column formula
I am trying to set up a column formula to round to the nearest whole number. Anyone know how to do this or if it is possible?
-
Automation providing more results than expected
I have created an automation where if a date field changes, then it will send an email. However, i am getting way more results than expected.
-
FORMULA: Conditionally Format Cells with Errors
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…
-
Adding a new project to a Main Roll-up
I started using the multi project portal. I will have new projects being added to the portal. How do I add new projects to the roll-up report?
-
Multiple Conditional Pathways to One Action
Hello, I am trying to create a weekly digest to send out once a week with multiple criteria using automations/ workflows. I am running into a problem because I am having to create multiple pathways due to differing logic which is forcing me to enter different actions for each pathway. Although I know I could recreate the…
