-
Automatic Comparision and automating the list of emails from two sheets into a third sheet.
Hi all, I have Registration sheet, which captures the email address. After registration, the individual gets email to participate in the challenge, with link to other Challenge form (and data will be captured into another sheet "Challenge Sheet"). Based on this email address column I have linked both the sheets, and as…
-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
Removing Duplicates
I've added a helper column that flags them as a check box but how do i add another to eliminate the duplicates? How do I add another to remove duplicates automatically?
-
Total Float - No Longer Working - Returns Invalid Value
I added "Total Float" to my schedule in late March. The calculation appeared to be working correctly at the time. Over the past few weeks, I noticed more and more activities would return "#invalid value". Now everything in the Total Float column as "#invalid value". Is there something that I need to do to refresh this…
-
Looking for a formular to help with a rooming list...
I have lots of passengers on separate rows. I have a heading row of dates. I then have a sequence of 1's in a grid that show which nights a person will check in for 1 over night stay. In the first example, my traveller will check in on 17/06 and check out on 24/06. I am currently having to update the columns manually when…
-
Smartsheet and Workfront Integration?
Does anyone have any experience integrating Smartsheet and Workfront? I am in the process of building out a Project Management solution for a client and just learned that the Project Manager who might be running the platform is more familiar with Workfront. Does anyone have any insight they could share on the following?…
-
Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
-
Assessment Resource Management and need training on linking budget and options with booking time
I am currently assessing RM to purchase with Smartsheets (which we are currently successfully using for the management of projects). I need some structured training to understand: How to implement phases, once set up in project setting. How to book to a particular phase (and hence against that phases' budget) Options for…
-
Dashboard issue
Hello there I have an issue when i create a dashboard, the colors of the cells disappear when i save the file as pdf. I use Smartsheet for KPIS and it shows the color of the percentages result as i set it up in different colors based on the performance, but when i save the fil all the colors disappear. Please see the…
-
Smartsheet business user - How to activate Resource Managment included in plan
I am the system admin of our Smartsheet business account. I have enabled Resource Management in Smartsheet setting Feature enablement. but I am unable to log into https://rm.smartsheet.com/siwith my Smartsheets account. How do i active my RM account.