-
Count down in days formula
I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each task and predecessors I then have the calculated "finish date" column for each tasks and each phase. I need to create a…
-
Help with a formula
Hello, This is probably a basic question... I am wondering how to input a formula that would allow me to calculate the value/price of something based on a drop-down selection. For instance, column A would have a drop-down options listing different tree species. For example, Redwood, Elm, and Walnut. Column B would have the…
-
Can I create a If Then statement using a date in smart sheet?
I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any intuitiveness. How could I do this? Here is an example Resource . Duration . Start Dates, End Dates LD 2 days . 8/29 8/30 AD 1…
-
Enhancement request - search visible rows only
Is there a search option that will only return results for visible rows? I'm trying to search for something and I don't want information contained within hidden rows to be returned.
-
Uploading large excel sheet
Yes, I read the blog posts from 2016/2017. I tried loading a sheet with 32 columns and received an error message indicating I had over 200 columns. In my opinion, the error message is misleading. Submitted this to SmartSheet support. Just wondering if anyone else is having an issue of this nature.
-
Calendar with multiple date colum
Hello: I have prepared a Master Calendar to have all our events in one page. Nevertheless our situation is not that our dates come from different smartsheets but that the dates come from different columns in the smartsheet. Eg. Date #1, Date#2, Date#3 in one line (different columns). This is because sometimes our Xservice…
-
Invalid response from JIRA. statusCode: 400 during Smartsheet for JIRA Workflow sync
I have set up a Smartsheet for JIRA Workflow and keep getting the below error message (screenshot also attached) for any rows created in Smartsheet (vs. ones originating in JIRA): Invalid response from JIRA. statusCode: 400, reasonPhrase: Bad Request statusCode: 400, reasonPhrase: Bad Request What I want to do is use…
-
Report Builder: Adding Columns
Hello, I am building a Project Repository in Smartsheet. I am creating instructions for how to build a specific project report from the repository and looking at the report builder. Is there a function to be able to "select all" of the "columns" to be included in the report? In addition, is there a way to set them up in an…
-
Chrome app closing without a warning
Hi all, When I run smartsheet in chrome browser, if I try to close the tab and there are unsaved changes, I get a warning about that. However, when I use the chrome app, if there are changes to be saved and I close the app, then it closes without any warning, and hence those changes are lost. Is there any way to fix that…
-
Web Form Submissions Disappearing
Hello, I have a web form that I'm using to collect information, and it has been brought to my attention that a number of rows that were submitted by users, and for which they received confirmation emails, never showed up on the sheet. This poses a huge problem as each submission represents a request to process a payment,…
