-
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…
-
SUMIFS Statements
Hi I have been having a lot of trouble getting SUMIFS statement to work always having the result unparseable - =SUMIFS(FTE2:FTE589,Fund Source2:Fund Source589,"MEMS",Unit2:Unit589,"Aquatic Environment") I have tried multiple times with just the column title and also selecting cells - I can get the statement to work…
-
I want to controll a resource that it is different allocations rate at each point in a same task du
I usually set allocations rates as average during term. But,When the task is long term, it is different allocations rate at each point in a same task. And if I set allocations rate to another task at low loard point,Smartsheet alert the over resource by caliculating rates. （Because of the allocations rate is average during…
