-
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…
-
Alert Email Triggers a Checkbox
Hello everyone! New to the community, but loving how detailed Smartsheet is! I am setting up alerts to trigger when a due date is approaching, 6 months, 3 months and 1 month to staff whose certifications will expire on that date. I would love for the alert to trigger an additional action, to check a box in the cell…
-
Disable Notifications/Reminders while "building" schedule?
My team and I are getting notifications and update reminders for sheets that I am still building (it is a copy of another sheet I'm using to create a template and it has all the built-in notifications we eventually want). Is there a way to "disable" the notifications until the schedule has been baselined? I don't want to…
