-
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…
-
Using Zapier to input formulas
Hi, I have been trying to use zapier to import a VLOOKUP formula, and the formula leaves Zapier clean, but in smartsheet it wraps in a single quote, example '=VLOOKUP([Sales Order #]4, {SL_MS_PM ALL}, 11, false) but when I enter it without the = the single quote does not happen as soon as a string starts with a = it adds…
-
PMO Governance templates ?
Team, This question may not be related to smartsheet. Based on your experience, what is the best source for ready-to-go powerpoint templates for PMO documents like Charter, status report, Budget summary. I know there are some online paid ones. But wanted to see what you all recommend. Thanks
