-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Data Loader Expression Input value
I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…
-
Update request comments
Update requests are great, however none of the comments get stored within Smartsheet but only get sent as a part of an email. This way discussions get lost that should remain part of the row it is about. Copying and pasting these discussions is just double work. Can we please get away to ad them to tow discussions?
-
Summary rollup
Hello, I've never used Smartsheet and would appreciate your help. I'm working on a budget, we have 40 departments and each department needs to submit their budget. So I have 40 sheets and they are exactly the same, (same columns and same rows), the only difference is the data. What is the best way to add up all these 40…
-
Using Resource View without 'named' Users
We want to use Smartsheet to build out our sales pipeline (consulting biz) and expected resource allocation. However, we don't have 'named' users (resources) until the project closes and we find the correct contractor. Is there an easy way to utilize resource views but without having named users invited into the smartsheet…
-
IF AND Function
Dear Smartsheet Wizard, I'm trying to create a function but I'm running into an error. The IF - And function I'm creating basically needs to do the following: If salesperson 1 is = "Yan" then deduct 100 from Profit and his commission should be profit*0.5. Otherwise, deduct 100 from Profit and commission should be…
-
Return 1 if YEAR and MONTH is equal TODAY
Hi, I have a formula: =IFERROR(IF(MONTH([Sale Date]2) = MONTH(TODAY()), 1, IF(MONTH([Sale Date]2) = MONTH(TODAY()) - 1, 2)), " ") and it worked until we have two years in one sheet. I would like to know how to add YEAR to this formula so that we can compare not only MONTH but also YEAR. Thanks.
-
Connect email notification with smartsheet for specific users
Hello, i was looking to create a new project using smartsheet to receive alerts from specific email addresses and to log the activities into smartsheet, those notifications will be received by specific users (their email addresses). how i can start implementing that and is it doable or not? Thanks!
-
COUNTIFS - Overdue tasks
Hi, I am trying to count live tasks that are overdue but I am getting #INVALID DATA TYPE This is the formula I am using =COUNTIFS(Status:Status, <>"Complete", [End to End Due Date]:[End to End Due Date], <=TODAY()) Any ideas? Thanks Karen
-
Workload over Calendar Duration
I am very new to Smartsheets and am in process of educating myself on the product to help develop some staffing workload tools on a project basis over time. The goal is to help us analyze how employees are allocated on a project over a calender timeline. For example, we use project milestone deadlines to break up a project…
