Greetings. I have a Real Estate Property "Rehab Project Plan" with tasks that I would like to assign to a vendor (i.e Electrician) so that I can manage his tasks and collaborate with him. I do not wan…
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 li…
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 …
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?
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…
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 su…
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:[Listi…
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,…
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, * I…
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 M…
