-
Question of automation "when rows are added" criteria
Dear All, I am new to smartsheet, and trying to set up some automations, to alert someone when a new row/ action is added. I am not sure the exact definition of "when a row is added" , it seems that I really need to insert a new row in order to fulfil this criteria. for example, if I make use of a blank existing row and…
-
Out of Memory Error
I was trying to edit a formula in a cell for just one row which worked as usual. But once I converted it to a column formula it just stopped. When I tried to hit the save icon the web page show 'Error Code: out of Memory'. My sheet being edited has approx 4500 rows. This is the first time I encountered this problem. Need…
-
Select Specific Rows in a Report to create a Chart
Creating a chart in a dashboard: Sourcing data from a Grid sheet you can select, i.e. Row 4, 5, 6 BUT if you are sourcing from a Report, then you can NOT select ONLY rows 4, 5, 6 for example. Smartsheet automatically selects ALL rows in the Report to create the Chart. The report I have, contains around 50 rows, which makes…
-
Comments section - ability to add in forms
Hi all, I saw this had been asked a year ago and it was suggested to use Zapier, but that's not a solution I can use. Are there any plans to enable the comments so it can be added as a field in a form. We use forms for initial intake, and have to create a column called "Notes" so comments can be added. It redundant and…
-
Forms - ability to add multiple fields
Hi, I've looked everywhere but cannot see if this is possible - or a work-around. I want to use the forms to collect information from site. One of the most import pieces of information is deliveries. So I have it set up so that "Materials" is a field/column, and then multiselect, and a second column for the quantity. This…
-
Forms - ability to add multiple fields
Hi, I've looked everywhere but cannot see if this is possible - or a work-around. I want to use the forms to collect information from site. One of the most import pieces of information is deliveries. So I have it set up so that "Materials" is a field/column, and then multiselect, and a second column for the quantity. This…
-
Issue with formatting being changed
Hello, I'm having an issue with one of our sheets and the formatting of it being changed. We have checked the activity log to try and identify the change but there is nothing helpful. I've already locked the sheet so other users cannot make changes but I am wondering how the formatting could change (all the data is still…
-
Summarize two columns
I'm trying to count the # of instances based on criteria from two columns. I must be missing something from my formula. I'm trying to count the total how many times "SRC" objectives there are that do not have a status of Blue. So, I want it to count statuses with "Red, Green, and yellow" where the business vertical column…
-
Can an IF/CONTAIN formula look to another cell to return a value?
Is there a way for the true portion of of the formula return a value_if_true from another cell. If Column 1 contains a specific text string, it would return the value of Column 2? =IF(CONTAINS("Specific Text", [Column1]:[Column1]), [Column2])) So for example, the formula would be in Column 3 : Column 1 @row has HOUSTON…
-
Is the inability to make changes to a Smartsheet project plan from 10,000 ft a bug or a feature?
My company intends on using Smartsheet to feed 10,000 ft, in addition to feeding other functions. I am only interested in the resource management function in 10,000 ft and would like to make my resource allocation through 10,000 ft since it is a much more user friendly interface. Right now that is not possible because…
