-
Notifications for when something DOES NOT happen
Hello, We have an important task to do daily at my workplace, and I would like to set up a notification system if the task does not get completed. The idea is that an employee completes the task and then submits the form. If one form is not submitted for the day, an email goes out at X time to notify the supervisor. I…
-
Approval Request
I'm trying to set up a workflow process for OOO requests. I would like there to be Approver comments if the request is Denied but I can't seem to get it to work without having the Approver log into SmartSheet to enter the Approver comments. Any suggestions would be greatly appreciated. Thanks -Peggy
-
A user can't access sheets
Hi, Since last week one user can't acces to sheets anymore. -She can't see old sheets neither new sheets, -She see's the list of sheets she should have access but can't open it -Her team can access -Her count is active, i also activate a licence for her since she report the bug, -We try in private navigation and after the…
-
Disable sharing with free collaborators
For sheets owned by licensed users, is there a way to disable sharing to free collaborators (i.e. only allow sharing with licensed or non-licensed users), either on a per-sheet basis or at the account level (i.e. for all sheets owned by licensed users). Also, I think it would be very helpful to add a "user type" column to…
-
Stuck trying to rollup with index, vlookup, and match
Hey folks, any idea how to pull this information onto another sheet horizontally? Basically, I am trying to consolidate some project information as seen in the "Source" screenshot. This particular sheet has the status for multiple items for the same project, but lists the same project on multiple rows. You can see this in…
-
SmartSheet Recent Update - Attachments/Versions
With the recent update to SmartSheets, our company has seen a few issues. The first issue has been the version numbers. If you look at the example below, the version numbers are out of order. We deal with a variety of freelancers that don't work for the company, but rely heavily on the version numbers. Now with them being…
-
Remove card count in card view
Hi Is there any way to remove the card count which is shown alongside the heading in brackets at the top of the page on each lane e.g. in my case Saturday (24) Sunday (24) etc where (24) is the number of cards in the lane. Thanks Gerry
-
Forms Permissions
I created a Portal/Dashboards with forms on them for employees to collect data. If they do not have edit rights to the underlying sheet, can they still add via the form? Also, is there a way to catch a duplicate entry?
-
Which is better in this case = Nested IF statement or using two formulas related to other columns
Hi, In the spirit of efficiency of memory usage, I want to figure out which methodology would be better: In either case, A/B are columns used to toggle several sheet functions as they relate to the heirarchy level the row is. * Use a nested IF statement: =IF(A@row = 0, SUM(CHILDREN()), IF(B@row=0, INDEX({REF Share},…
-
Cell Linking Issue
Hi all, I am new to this community but have read numerous feeds posted here and found them really useful. I have now run into a problem of my own that requires some help. I have created a form for our business to complete. The completed lines (Cells) are then linked to another sheet for data collection. The problem here is…
