-
Date Formula based on Last Modified is off
I made a column i called Status Date. I used the Formula: =[Last Modified]1 so that it would just display the last modified, but also have the option to be over ridden manually if need be. My problem is that the Last Modified is showing Today (7/20/2017) but my Status Date field, which should show the same date, is showing…
-
formula for date to land on the following Tuesday
Hello, I am calculating a date based on another date: =[Proof to LSI]70 + 49 I would like to add to this formula so that the date will always land on the following Tuesday. Any suggestions? Thanks, Kim
-
Consolidated SmartSheet
Hi all, I am pretty new to Smartsheet and in need of some help. We are using smartsheet for an upcoming budget task. I have created over 50 different sheets. In each sheet there is a column with checkboxes. I want to have a user check the box when the specific task is completed. My question is, is there a way to create a…
-
Workspace Commets Via API
Hi All, I want to display my workspace comment to the website via API, I can see the comment section which states that we can pull the smartsheet related data but my need is to get the workspace comments. Please guide me how i can get the workspace comments from API in smartsheet. Thanks
-
=IF formula ???
I am trying to create an alert formula. I need to contact people every 15 days. I have one cell that states "Last contact" and the date, another that states "Next contact"and the date, the third cell, I would like it to state "Contact" in red. Can anyone help me formulate the "Contact" cell?
-
Adding 30 or 60 days to a date based on another Cell Value
Greetings, I am trying to calculate either 30, or 60 days from a date, depending on the value of another cell. Example: Cell 1: Date Cell 2: $ Value of less than 50k or $ Value of $50k and up Cell 3: Date plus 30 or 60 days, depending on the value of Cell 2. Any ideas? Thanks!
-
Smartsheet quirks this morning
Is anyone experiencing some quirks with Smartsheet this morning? I am using the same commands I would normally use to copy paste and it either does not recognize the paste or pastes something from another copy session. Very strange. Hoping my computer is not about to crash. Thanks!
-
Sum values from a report
Hello, I have a log sheet that records a project name, resource and hours, with many rows of entries. I would simply like to create a report that sums all hours by project. I don't see how this works in the report function, but it seems like it should be doable. Any help would be appreciated. Nick
-
LOOKUP
Can someone please help? I cannot figure out why this formula is not working. Fyi..the Current Designation column is column number 2.
-
Send update request to a 'group'
Hi All, new to smartsheet so apologies if this has already been asked but still finding my feet. I can see I can send a mail to group from the row but I want to be able to send an update request to a group, if a member of the group updates and sends a comment then I can see that it was updated by Steve@... I have tried…