-
How to validate a sheet cell when user saves the record?
Is there a way to validate when a sheet cell contains incorrect data and tell the user to correct it then WHILE STILL IN THE SHEET, without sending an email for the user to go back and correct it? My scenario is that we want people to report how many hours they worked on a project for a given week and use the week ending…
-
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…
-
Removing Shared Users
One thing that frustrates me the most is not being able to remove shared users easily. I know in the User Management section I can type in a e-mail address and have that person removed from all shares. However, I have 100+ shares. Why isn't there a list that shows me every person that is allowed to share on each sheet.…
-
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…
