-
IF(Is Parent Row....
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 Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, "Never") The formula for check is a parent row is…
-
How can I put a drop down menu that dynamically updates or adds another field?
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 choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…
-
Enhancement Request: Choosing which task to display on Agenda
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, and the ones he doesn't. I use a lot of titles or categories for my tasks and subtasks but most of the time they are…
-
Mobile App for entering data into SmartSheets...
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... just like Webform - but without going to that URL of webform... We are trying to track our Sales Leads - by asking sales team…
-
cost and efficiency trend calculator
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 would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
-
moving rows in reports (without using Sort)
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 rows if that helps). Sorting only changes the order numerically or alphabetically, which I don't want to do. Any ideas?
-
Status Order Tracking (similar to the Dominoes Pizza Tracker)
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 tell where their job is at (With Designer, Proof Sent, At the printer, Completed etc.) Does anyone know if this is possible?…
-
Cell Highlights Automatically
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 above and the row below are highlighted in white and initially the new row is white. How do I stop this from happening? It's…
-
Method for planning repeated tasks?
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 single task (preferably) or by having a seperate line for each date of said task with the start date automatically occuring at…
-
What formula to add to a "Days Remaining" field to pull from a date box
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 or red button) to remain statically green until the "Days Remaining" field gets down to 30 days remaining. At this point, I'm…
