-
Approval workflow
Hi Guys, Im new to smartsheet , please help me. I created an approval workflow then if the approver is not around how I am going to reassign it to other approver without breaking the approval sequence. Please let me know your thoughts. Thank you very much.
-
RGYB Automation
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <=…
-
DataMesh & Gantt Charts
I am working on a project that we are trying to DataMesh two individual Gantt schedules into one new worksheet together. I've not DataMeshed too much, but is this possible? I use a formula of "Row # + Site #" as my unique identifier for the config. I set up the config, and the first time I kept on getting errors, so I…
-
% complete is not rolling up from child to parent.
I was sent a Smartsheet project and am not sure how it was constructed. The % complete column for the child tasks have the amounts entered. The parent task does not report the calculated rollup from the children. I attempted to fix it by creating a new % completed column and entering the values by hand. When I entered the…
-
Is there a way to merge two Enterprise Account Users?
Currently there are two Enterprise Accounts created for some reason. So I am unable to add an Enterprise User from 'Enterprise Account A' through our User Management in 'Enterprise Account B'. As per instructions, if we delete these users from 'Enterprise Account A': 1. Will their Licensed User license be removed from…
-
Vlookup from Excel to Smartsheet
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching. I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and city's linked to those zip codes. This Excel sheet is used as a vlookup for multiple…
-
Interaction with Microsoft Sharepoint
Long story, short as I can make it. I started to create a list of links in Microsoft Sharepoint until I discovered that it seems to be woefully short with sorting, making child entries, etc. In Smartsheet, I am able to accomplish what I am trying to do with ease. Here's my question. Can Smartsheet and Sharepoint interact…
-
% Complete for a row based on 6 columns of check boxes
Hello - I have a task list that has 6 columns - each column has a check box. I am trying to determine a formula to calculate the % complete based on the populated check boxes. Ex: 6 Columns - if 3 columns were checked the % complete would be 50%, if 2 columns were checked then the % would be 33%, etc. can anyone help me?…
-
Licensed User deleted what happens to the associated License?
When a Licensed User is deleted what happens to the associated License?
-
Unable to Scroll While in a Formula
Hello, I am unable to scroll while editing a formula. For example, I am in line 648, and need to make it equal to line 45. If I simply hit =, and attempt to scroll out of view from 648 it gives me a #UNPARSEABLE error. I have been using SmartSheet for the better part of a decade, and never had this issue.
