-
Smarter Dropdown List Manager
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that list. Our Developers, using the Smartsheet API have created just that solution, in fact we have assumed that users will want…
-
Base rule off of 2 columns
I'm looking for a way to create a rule that would be: If Column "Status" says Funded, and Column "Fee" is blank, make the row Yellow Is there a way to do this? I can't seem to figure out how to get 2 columns on there to create the rule Thanks!
-
Add hyperlink to related sheet from the report
I'm creating a "summary schedule" report from the project schedule and would like to include a hyperlink to the full project schedule within the report for quick access. Any tips to offer on that?
-
Gmail add on for Smartsheet
The Gmail add on worked twice, but now doesn't place the email into the spreadsheet. It still finds the spreadsheet and the rows, but when you either select an existing row or attempt to add a row the cursor circles for a few seconds then stops and nothing further happens. Not sure where to go next. Any help would be…
-
AIA G703 - Form Template
I’ve created a modified version of the AIA G703 form in Smartsheet for use in monthly tracking of my financing of a land development project. Each time a new funding request is made, a new sheet is submitted which includes a colum for “work previously completed” which needs to sum several columns from the previous funding…
-
Excel Formula Error
Hi All, I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1)))) The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the formula. Attached is a…
-
Update Request Rules vs. Manual Update Requests
When I send out a manual update request it says my username via Smartsheets, and if someone hits reply, it goes to my email. If I set up an alert and action, it comes from Smartsheet Alerts & Actions, and if someone hits reply it goes to automation@smartsheet.com, and I never see this email. Is there a way to have the…
-
Nested IF with COUNTIF
I need to use a nested IF with COUNTIF. Is that possible? The scenario is that I need to count the number of “Red,” “Yellow,” and “Green” balls that are in a particular row in another sheet. Then, * If count of “Red”>=1, return “Red” * If count of “Yellow”=1, return “Yellow” * If count of “Green”=8 (or all), return “Green”…
-
Attempting a formula with multiple criteria
Hi, can anyone help with the formula for the following required outcomes? * $0 if the management agreement has not started [Mgnt Start Date], * Equal to the chargeable amount [chargeable amt] if the Management agreement has started ie [Mgnt Start Date] in the prior month * Equal to the previous month [Jan 17] if the…
-
Lock single cell
Hi SM Team, What's the latest for this feature ? Is it possible to lock a single cell ? Thanks in advance for your answer
