-
emailing a form once a checkbox has been activated
Hello out there in smartsheet land, I'm trying automate an email of a survey form. I want the form to be emailed once a check box has been checked off. I've checked the formulas page and I cannot find the help i need . Any help would be greatly appreciated. thanks Donny
-
Worksheet Content Protection
Dear Community, Is it possible to hide and lock a specific section (rows) of a worksheet, so that only Admins and specific nominees can unhide and modify them? The data within this section is commercially sensitive, so only a few users will need access to unhide and edit. I would rather avoid the need to separate out to a…
-
Resource Management & Resource Views doesn't seem to work!
I introduced Smartsheet to our company about a year ago and since ten it has become a business critical tool for all our projects and client collaborations. We implemented the resource management feature about 3 months ago and consistently seem to encounter problems. Has anyone else found the following issues and if you…
-
##Help ME please "i can t continue to work" SumIF##
I post a problem 2 days ago some response but still doesn t work, new to smartsheet but my work is blocke now problem Hello @Craig and other Helpers i experiment the same issue than other sorry for my english but i m french i copy your formula below and try to adapt with "laserjet" type i want to make a sum if a name…
-
Cash Flow Projection in Projects Sheets
Hi, I am using =IF(AND( ... )) to project in which month a disbursement will be made in a project planning sheet. Does anyone use an easier faster way of scheduling disbursements and depreciation? Regards
-
Duration in a summary task show "hours" instead of "days"
I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks? Thank you, - Blake Chesley
-
Non-working days are no longer greyed out - Bug?
Hello, We have recently begun working with Smartsheet and we detect that nonworking days are only greyed out when the setup gantt menu is openned. Is there a bug in our system or a configuration is needed? It occurs with a single new project without changing anything. We have seen a similar discussion but without…
-
Count Cells by Color
how do I count cells of a specif color in a row? Countif does not seem to do this as it does in Excel.
-
Round to nearest 0.5
Hello, We are building a time management sheet based upon a simple Smartsheet feeding information from a Form. After we've received the information we want to round the calculated results to the nearest 0.5 (see screen capture) The data we receive are collected and calculated in plain text/number columns. The Round formula…
-
Is it possible for summary bars on Gantt to be subject to conditional formatting?
Okay - My conditional formating on this sheet is set to change the color accross the entire row and bar. If status is checked, the gantt bar goes to grey, if not checked, it stays green. The summary bars are not changing. Is this possible? Thanks Jef
