-
Conditional Formatting & Date Period
Hi Team, I am wanting to apply CF to a sheet with a date field. I would like to apply CF when a date falls (from todays date) within 3 months, another CF for 3-6months and another with 6+ months - thing is this becomes a 'rolling' CF, aeaning that at some point the CF will change or adapt based on todays date. I am not…
-
Referencing checked state of Flag symbol using formula
I want to use a Flag column to mark high-priority tasks and calculate a reduced lead time. In a Due Date column I use a formula to add 7 days to the Received Date. I want to change the formula so that it adds only 5 days IF the flag is checked. I can't seem to find out how to reference the value of the flag cell, though.…
-
calendar view
My project management has a sheet for scheduled work. We have a color associated with each job according to who the technician is do it. Is there a way to add patterns to the lines as well to determine who is managing the job too?
-
Importing Excel - changes value 1 to checkbox
How do I avoid this? WQhen I import a value of 1, it needs to remain 1 as values in other cells remain numbers. This is not intuitive.
-
Salesforce
Hello, How can i use the salesforces customer informations in my sheet
-
Sequence of fields in update request
Hi All, Can anyone tell me if there is a reliable way to set the sequence for fields that are part of an update request? I'm using a report, with the fields ordered in the sequence I want left-to-right, and most of them feature in this sequence on the update request. However, a few fields are out of sequence and I can't…
-
How do I add today's date based on another cells data?
I know I am missing something simpe, but I want to add "todays" date based on a drop down selection of another cell. =IF(JAN6 = "Paid", TODAY()) When I use this i get the error: #INVALID COLUMN VALUE and if I add in the column and cell it gives me this: =IF(JAN6 = "Paid", JAN7 = TODAY()) #CIRCULAR REFERENCE Any ideas?
-
Enhancement Request for Sights: Horizontal positioning of fields in widgets
I miss the possiblity to align content fields in a widget next to each other . The available space could be used much better... Today the fields can only be aligned vertically like this:
-
Maintaining a list of small department's resources
My compny is small (about 15-20 resources with limited turnover). To allow all users to work` w1ith the same list of resources as I undestand it, because contact lists are not shared, each user (or maybe just PM) would need to create (or import) a list of names/emails that would then be available to assign to tasks using…
-
Is anybody using other app that is syncs with smart sheet for notes etc.
HI, I new user here. I would really like better discussion, notes,comments,brain storiming optioins. I think about evernote,but I like trello for brainstorming and other notetaking apps. I would like to link a trello board to a cell that woud be in sync or not(if I choose so). How should I do it ,without other users having…
