-
Data Loader Expression Input value
I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…
-
Update request comments
Update requests are great, however none of the comments get stored within Smartsheet but only get sent as a part of an email. This way discussions get lost that should remain part of the row it is about. Copying and pasting these discussions is just double work. Can we please get away to ad them to tow discussions?
-
Formula Only Column
Hello! Can the entire column have the formula in each cell without it marking it as a new row? Status Column = Drop-down Column State Column = Symbols Column (with red/yellow/green symbols) Goal: State column automatically updates based on Status column. Example: If Status column says “sent for approval” then the my State…
-
SmartSheet Jira Integration
Hi all, I'm new to smartsheet and have also purchased their Jira integration. I'm curious as to how many others here are using this integtation? There's a lot of quirks with the integrations so wanted to see what others thought of it and how they're using it. Cheers, Imran
-
How to right-size a Project Portfolio?
This question may be more on Project Management and Culture than it is solutioning in Smartsheet Software, but possibly some of you have done something creative in Smartsheet to help your organization. I have been with my organization for a year now and have been able to build out a project portfolio. Having the visibility…
-
# BLOCKED
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])" All that is doing is counting all…
-
If Index Match
Hi, I'm trying to figure out the due date for a submission if the dates remaining is >0 below is the formula I came up with, however it is not working. =IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remaining}, @cell > 0) Also, is there a way to do an Index Match or vlook up that gives me the…
-
Can Pivot Sheets shared or embeded in iFrame?
Just try the Pivot Sheet in the smart sheet, that is the something I am looking for. But whether it can be shared or embed in wiki. Which I don't need to export the result and do the analysis in the excel?
-
Automation Workflow - Error Check
Hello! I am setting up an approval workflow and have run into some questions. Example: Trigger: If "Status" is set to "Sent for Approval" Action: Send approval to "Final Approver" Now, it's a very simple workflow, but, if my "Final Approver" is not populated, or there is a typo, etc. Is there a way for it to…
-
Dashboard - Gantt Show Only Today Forward
Anyone know how to make dashboard widget of a gantt chart only show today and forward? It displays correctly in the Report Builder as there is an option in Settings > Timeline Display to check the box "Open to today's date". Can't figure out why it won't do this in Dashboard widget. You can scroll to today and it prints…
