-
Exporting to MS Project with Correct Dates
Hi, I am trying to export a schedule built-in Smartsheet to MS Project to share with a customer. When I export and open the file as an XML, none of the dates are correct. All of the other information appear to be accurate except the Start and Finish Date Thanks, Chris
-
Feature Request - 360 deg photo
Please allow us to link a 360 deg photo into a cell. Currently the cell will flatten the 360 photo in the preview (in the cell) and in the pop up window. Can we get the ability to link in a 360 photo?
-
Construction Submittal Log
Does anyone have a good construction submittal log template they wouldn't mind sharing? Thank you!
-
Issue with CountIf not correctly calculating
Hello, I am using the formula =COUNTIF(CHILDREN(), 1) + "" to count the total number of checked check boxes. However, The number displayed is 0 when I can clearly see the box is checked in that column. For other columns it displays a number but not an accurate count of checked boxes within the column. Is there a different…
-
#NOMATCH Error in VLOOHUP when values are an exact match
I have two sheets: Change Oorders and Change Order Pricing. IN Change Orders, there is a column called Task1 which is a dropdown menu. The values in the drop down were copied and pasted from Change Order Pricing, "Task" column which is the first column. I created this formula: =VLOOKUP([Task1]@row, {Change Order Pricing…
-
Regional User Group
My company and I are new to smartsheets and would like to form a regional users group. We are based in Lexington and would love to be in touch with other users in Kentucky and surrounding states. It would be helpful to talk and work out problems together as well as see how others are leveraging the capabilities. Thanks!
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Auto format phone number
Good morning, I'd like to have our phone column (text) formatted so that when I input just the numbers (ex 7195555555) it would format the number as (719)555-5555. Help? Blessings, Loann
-
Coping Dashboard
Is there a way to copy or save a dashboard as a template. Instead of having to make new ones from scratch?
-
Help with a join formula to view two columns in calendar view
Hello! I have several projects with many rows of information per project on one master sheet. I use conditional formatting to seperate/identify projects by colour. That colour coding applies to both grid and calendar view nicely. BUT I would like to combine a project code and task name in calendar view so I do not have to…