-
Gantt Chart Timeline?
Is there a way to have the bars in a Gantt chart to be all on one line? This way the info can be compressed similar to "Timeline View" in MS Project. Can it be done with SmartSheets?
-
Concatenate two cells
Hi, I need to concatenate data of two cell into one cell. I just use the formula "=[Cell1] + [Cell2])", which worked fine and gave the result "Cell1Cell2", however I need to have space or underscore between values of two cell like, "Cell1_Cell2" or "Cell1 Cell2". My practical requirement is: I need to concatenate "date"…
-
Linked Cells with Numeric Value not working in Chart Widget
Hi, I have a roll up of numbers for the total of checkboxes checked off in our main data sheet. I've linked that totaled value into a separate sheet via the link cell capability. That is somehow not getting charted, and is showing up as "Invalid data"? What am I doing wrong?
-
VLOOKUP is data type of TEXT instead of DATE - sorting is off
I am currently creating an report which looks up dates based on specific milestone tasks over a number of project sheets. When the vlookup calculation is entered and I hit the Return key, is it giving me an alert that the value is not in date format. Being the admin, I am able to override this. But when sorting, it sorts…
-
Using One Checkbox to Check Another
We have a task sheet that uses 3 checkbox columns (Sent, Received or Done, N/A). We have a formula that counts the number of tasks and how many are completed based on the Received or Done column. We are trying to make it so if the N/A box is checked, it automatically checks of the coinciding Received or Done box. Please…
-
How to get the sum only for a Specific Dropdown Value Selected
Hi, I want to get the sum for only the dropdown value selected: Here is the Situation: First Column: I have 3 Resource Type: 1. Offshore 2. Onshore 3. Remote Column 2: I have resource Name Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work) Now I need to calculate: 1.…
-
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…
