-
Sharing Dynamic View & Dashboard with Non Users requiring sign up
Is there a way to share Dynamic View and Dashboard access to non-users without requiring them to sign up for smartsheet?
-
Hierarchy issues
Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I have been tasked with taking over admin/owner duties now. I understand the basics and…
-
Nested Or within Countifs formula
Hi, I am hoping to see if I can get help with the following formula: =COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], <>"internal comms") Essentially, my goal is to count items that are for "HGIT" that are either complete or approved but not…
-
Formula to Roll Up Task Status
Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Parent shows as Not Started if: All children are either Cancelled or Not Started. Parent shows as In Progress if: Even one child…
-
Is there a way to create multiple rows in a sheet based on a numerical answer on a form submission?
I'm trying to track new hires via work orders. I'm wondering if there is a way to create the number of rows indicated in a form submission on my tracking sheet? For example, should I indicate that I am trying to hire 8 individuals for a certain role, is there a way to automatically add 8 rows to my sheet that copy all the…
-
CountIf and Multi Select columns
I am trying to count the number of instances a value appears in a multi select drop down column, but I keep getting an unparseable error. After searching the existing help forum I have tried both the CONTAINS and the HAS functions as follows, but receive this error for both of them. The formula's I have tried are:…
-
Return Multiple Look-up Values in a Contact List Field
We have a reference sheet which has a first column of Client ID followed by columns for Analyst Email and Manager Email (both are Contact List column type). On another sheet we have multiple columns and are trying to populate both the Analyst Email and the Manager Email values into one contact list field based upon the a…
-
Formula is not persisting when value is removed from cell
Hello, We are having an issue with cell formulas. The cell formula is erased when we change or delete a value in a cell. Here is the formula we are using: =IF(Status4 = "Complete", "In Progress") The formula should first check the cell status in Row 4, then change the cell status on the row where the connected cell is…
-
Function to check box if lookup is true
Hi Is it a possibility where a column contains checkboxes, for a function to sit behind that that if a lookup to another sheet returns a true value, the checkbox is ticked? Specifically for the lookup to be: On Sheet1: If the value in col ID and the date in col Next Inspection Date appear in sheet2 (below) in the cols…
-
Trouble with Project Management & Smartsheet Restrictions
I am trying to create a Smartsheet to track project completion (Integration) for my company and am running into multiple hurdles with the reporting. I'd love to hear your insight on how to overcome these issues without having to turn off all dependencies. Without dependencies the product doesn't offer much for project…