-
Update Request Links
Hi - I'm wondering if there's any way to capture the actual Update Request link (what comes through in the email when you send the Update Request) in a report? Our account people get tons of Update Requests, and don't always have the info to follow up immediately. So, rather than have to sift through emails, is there an…
-
Is it possible to hide dates in a project plan and display week 1, week 2, etc.?
I'm setting up a project where the start date is still to be determined. I have been asked to provide a column that has the week a certain activity needs to occur in. For example, instead of kicking off the project on 25/09/2023 the Grid View of the project plan should have a column in it that shows the project kicking off…
-
Can smartsheet create and display Binomial Trees?
Hi, I was wondering if anyone has tried to create and display a Binomial tree within Smartsheet? Is it possible, as I have been unable to find a template for it. I don't need it to run the calculations more for display purposes only. Thanks.
-
Combined Multiple IF CONTAINS Functions
Hi, I have the following formula =IF(CONTAINS([Column A]@row, {Sheet A Range 1}), "Sheet A", IF(CONTAINS([Column A]@row, {Sheet B Range 1}), "Sheet B") Now I want to add if both sheets contain [Column A]@row, result: "Sheets A and B", How do I add this last part in addition to my current formula? Any help is appreciated,…
-
Enhance Auto-Populate Feature for Drop-Down Lists
For long drop-down lists, it is nice to be able to start typing a value in a cell and use the auto-populate feature to reduce the options from which to select. Currently, the auto-populate feature only works if the user starts to enter the value exactly as it appears on the list. Instead, please enhance this feature such…
-
How to set up an email reminder 7 days after creation date
Greetings, I'm trying to set up an automation to send an email 7 days after creation date but I'm having problems. I tried using the function =IF([Creation Date]@row) > TODAY(+7), 1, 0) but it isn't working as expected. When I change the date with a test date from a date column, it works fine. Any ideas what I am doing…
-
Any idea on what Understanding and Hand on experience in Tabular user interface means
The phrase is showing up in job descriptions. Thank you
-
Date Calculation not working correctly
In my Operating Calendar sheet, I have a Due column (date). This due date column should be calculating based on a formula that adds the "Days From Pricing Group OR 1st Departure Date" column to the "Pricing Group Date" Column (=[Pricing Group Date]@row + [Days From Pricing Group OR 1st Departure Date]@row). Both the "Days…
-
How to calculate Status Indicator using %Complete and Target Finish Date
I am trying to achieve the following: IF the %Complete equals 0%, then status indicator is Gray. IF the %Complete equals 100%, OR the %Complete is less than 100% and Today is before the Target Finish Date, then the status indicator equals Green. IF the %Complete is less than 100% and Today is within 1 week of the Target…
-
How can i read activity log using c#.net through API...?
I need to restore a specific row which are deleted from the original sheet, and i am using API to achieve this with C#.NET. Our idea is to create new helper sheet using c#, which contains deleted rows in it, That has to get updated by reading data from activity log May i get any suggestions. Thank you in advance.