-
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
-
Smartsheet for Outlook imports wrong email date
I am using Smartsheet for Outlook to import emails to rows. The row is created and the email becomes a comment - but the date/time in the comment does not the reflect the real date/time of the email. I have attached a screenshot. Any thoughts?
-
If, Or, And
I'm trying to work an if/or/and statement to return one of 2 numbers. It would look something like, If X or Y or Z and A or B then 0 else 8. It has me completely stumped my results are always unparsable. Do anyone have a direction to point me in? Any help would be greatly appreciated.
-
Customized Message in Workflow
I am trying to create a ticket system where a staff creates a ticket via a form Lets say "Fix the broken faucet" I then want to send the user back an email saying Your Ticket number ABC-123 has been created Then the user can contact a plumber and say please reference Ticket Number ABC-123 for your work I was hoping I could…