-
Return blank when count total is zero
Can you give me a variation of this formula that delivers a blank if total counted is 0? I want to use it in forward months so I don't have to update the metrics sheet monthly, if possible. Thanks, Lisa I tried the IFERROR and IF(COUNTIFS( I could find but most deliver Incorrect Argument. =COUNTIFS({4Q2025 FPG thru Oct…
-
Anonymous Survey
Hello, I am looking to send a survey to my team, I would like for it to be completely anonymous, is this something Smartsheet can do? If not is there something we can do to make is as anonymous as it can be? Thank you!
-
Nested IF statement
Hello - I need some help trouble shooting a nested IF statement. In our project plans, we have a column that show the decision made for a specific phase of development. The are Go, NoGo, Transferred and Terminated decisions. I have recently added the Transferred decision. These decisions are driven by multiple factors in…
-
Change Order Management
Does anyone have best practices for collecting and managing Change Order requests for Project Plans please?
-
Cross Sheet Reference
Trying to create a cross sheet reference that counts #s from a specific column in another sheet. =countif({Am-Van: Vehicle List Range 1},[Type of Service]:[Type of Service], "BLS") Comes back as #UNPARSEABLE The COUNTIF statement works in the referenced sheet but not when it is cross referenced. Is there a comma or bracket…
-
Sheet Summary in Table View
How do I view sheet summary fields in Table View? I have a large sheet that only works properly in Table View, but I don't see how to get to the sheet summary page and how to add sheet-level attachments. If I switch back to Grid View to access those, the sheet won't save because it has too many cells. I'm in a Catch-22…
-
Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
-
Expanding My Index to additional Sheets
I recently created a new archive file and want to update the formula so that it will also search the new sheet. Here is the current formula I have. it works on current sheets but not the new archive. Any help or suggestions would be appreciated. =UPPER(IFERROR(IF(LEFT([Excel PO Approval Number REQUIRED]@row , 2) = "PO",…
-
ServiceNow to Smartsheet Connector
Looking to find out if there is a connector between ServiceNow and Smartsheet, just like there is between Salesforce and Smartsheet. As I'm looking to set up a sync to pull data, not necessarily Project data, from ServiceNow into Smartsheet? Is that possible?
-
Copying Workflows between Sheets
In my operational work I use Sheets as Action Trackers for all the countries we are implementing my project. When I was tracking about 5 countries I got the idea to create workflow that if any task is assigned to me the line is automatically copied to another sheet that is actually my Kanban Board so in one place I can see…