-
Auto Formatting with New Row Entry (via Webform)
Scenerio: Row 1 and Row 2 have a Blue Background for all 6 Columns. I created a webform to add above these 2 rows for all 6 columns. When I submit the webform, the added row does not receive the lower background on it. This use to work, and now for some reason it is not. Let me know if anyone has any fix, thanks!
-
Report Errors in Cell History
I have a report that goes out daily showing which items are past due. The report is generated based a column that creates a flag when the line item is past due. On Monday the report went out but says that some one made the change to the cell according to the cell history. The report also looks the receivers that it came…
-
Features that Smartsheet Should Add
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…
-
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
-
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…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Release Notes Link hard to find
Shaine, I was able to preview the formula Help and Activity Log prior to the release. Really liking the Activity Log for a sheet we recently rolled out that has over 500 users updating it. I'll have to spend more time on the formulas to give feedback. I did notice that the Release…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
Comparing Actual Duration to a Projected Duration with a +/- days
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration) The trick here is you need to strip the "d" from the value to allow computations. =(VALUE(LEFT([Projected…
-
Create a live copy of my sheet
I would like to be able to re-order my sheet without the parenting hierarchy in place. I was thinking that if I create a live copy that is always up to date but does not have the parenting information this would be easy. Basically, I have task assignments under projects. and different people are assigned to different tasks…
