-
Smartsheet dashboard view
Hi Team, Can anyone suggest me how to create this kind of view in smartsheet.
-
Sales Pipeline - Period View
Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular Financial Year in the dashboard. Any suggestions on how to go about this?
-
Need help creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. -- If columns "Reviewer Assigned" and "Approver Assigned" are not blank, I want the status to automatically change to "In progress." --…
-
Unparseable???
I am trying to figure out why my formula keeps saying #UNPARSEABLE I am trying to take the first four digits of a project number and join it with 2 digits that are the suffix to create a new project number. Please help! Here is the formula: =JOIN(MID([Project Number]1,1,4):[Project Number Suffix]@row)
-
If Formula with Dropdown conditions
I am trying to get an IF statement to check conditions of 3 dropdowns and based on those being true either add a specific value or do a calculation. Below is what I am trying, but I am only getting it to populate N/A, no matter what the values entered are. If the 3 that are entered below are true it should enter the value…
-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
Need assistance creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. If Columns A, B, and C are blank, I want the status to automatically change to "Not started." If Columns A or B are not blank, I want…
-
My formula with reference to another sheet is no longer working.
It was working fine and then just seemed to break. Below is my formula. I'm doing check for PTO which we maintain in a dif smartsheet. =IF(OR(COUNTIFS({RDI Calendar Range 1}, [Assigned To]@row, {RDI Calendar Range 2}, >=Start@row, {RDI Calendar Range 3}, <=Finish@row) > 0, COUNTIFS({RDI Calendar Range 1}, [Assigned…
-
Need help with "WEEKNUMBER" and "TODAY" formulas
Hi Community, I am having a hard time getting my "WEEKNUMBER" and "TODAY" formulas to work and I am hoping someone can point out what my mistake is. I have created a metrics sheet to count the number of action items due over then next 6 weeks. I'd like the sheet to show rolling weeks ahead. For example: Current Week,…
-
How to automatically populate a cell with same info from another cell on the same row
Hello, First time SmartSheet Community Member! I have a sheet with specific rooms locations in separate columns. What I am trying to do is automatically populate the Room column with anything that’s populated in any of the Building Room columns to the right on that same row. I thought a VLOOKUP was the best to achieve…