-
Créer une ligne de date réccurente
Bonjour, Je ne trouve pas le moyen pour faire une ligne avec des dates réccurentes (par exemple réunion tous les mardi à 15h ou tous les 1er mardi du mois). Merci de votre aide.
-
Cell reference formula
How can I create a formula from two columns that will result in pulling in the value from a third column? Column1 (text) = Column4 Column2 (text) = 3 Column3 (date) = Column1 + Column2 Ideal Column3 result = [Column4]3 Please let me know if I can clarify anything, it is a little confusing. Thanks
-
Multiple Formulas: Formula SUM conflicts with Formula IF Logic
I have a sheet set up so that when a checkbox is checked, the price of a product generates in the column next to it. I also want to be able to capture the sum of everything in the price column, but when I input an =SUM, it reads as 0.00. Is there a way for the formula to calculate the sum of values that are generated by a…
-
Still Looking for an IF function that does nothing to the cell if False
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
-
Confused by NETWORKDAYS results
I have a formula such as: =NETWORKDAYS([Planned Start]1, [Actual Start]1) When the Planned Start date is say 10/29/14, and the Actual Start date is 10/30/14, the result is 2. To me, the difference between those two dates is one day, not two. I don't have any holidays set for these dates, and I've tried wrapping Actual…
-
One tab, multiple reports?
Smart Sheet has proven to be an amazing tool. In using it, I have built several reports that are starting to take up too much space on my display. Some of these reports are very similar (Quarterly reports, for example, are taking up four tabs per year) and I want to consolidate them into one tab. How do I create multiple…
-
Consolidating names in a Columns
We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column. I have gotten…
-
Calculating Years Of Service
Hi Everyone, I currently am importing a sheet to manage in SmartSheets and one of my cell formulas is not functioning. Can someone please let me know if there is a work around to this. Currently in excel I have it as a =datedif formula. Smart Sheet currently shows the following error in the sheet #unparseable. Thank You
-
Count Children if Criteria is Met
I'm trying to get the =COUNT(Children()) formula to work with a criteria. For instance, I have children that require a status of 'In Progress' or 'Completed', when the status is 'Completed', I want the Count to reflect the number still 'In Progress' as opposed to ALL the items listed below. is it possible?
-
Is there a way to flag a row if not indented
Hi all, I'm fairly new to Smartsheet, and have been fiddling around with it on my own, trying to build a database to keep track of product registrations (see the screenshot below). It uses three levels of heirachy: - Product level - Country level - Application level It's very large, with thousands of rows, and will be…
