I am using the below to calculate the "days since last contact" and it works nice. However, if the row is a parent I want to retrun blank, i.e. <> =IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Con…
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to ch…
Hi, A great way to improve your existing features regarding Sync with Google Agenda (or even the regular Agenda view) would be to allow the user to check or uncheck the tasks he wants to be synced, an…
hi. Is there any mobile app which acts as WebForm for filling up smartsheets? i m looking for a solution in which my team members can enter data from their mobile app - which goes into smartsheet... j…
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I wou…
Is it possible to move rows around in a report without using the Sort function? I have a report that pulls from 3 sheets, and I want to change the order of the rows from each sheet (not individual row…
Was wondering if its possible to create an online sheet for my clients to be able to get Status updates? Ideally I would want them to go to an online sheet and put in their Invoice number and it will …
I'm using the Event Planning with Budget template. Whenever I add a new row, then type in text in that row, it automatically highlights specific cells in that row a grey color. Even though the row abo…
Hi there, I'm wondering whether there is a current method - or planned feature - that will enable users to easily create recurring tasks? I envision this either occuring as multiple dates within a sin…
Hello, I am trying to create a formula for a column that will determine the number of days remaining from an expiration date. Furthermore, if possible, I would like a status indicator (green, yellow o…