-
TRYING TO RETURN THE DAY OF THE WEEK.
trying to get the Day of the week (ie. Mon, Tue, Wed) to return based on a date column. Tried this, but getting and unparseable error - what am I missing? =IF(WEEKDAY[Bid Date] = 1, "SUN", IF(WEEKDAY[Bid Date] = 2, "MON", IF(WEEKDAY[Bid Date] = 3, "TUES", IF(WEEKDAY[Bid Date] = 4, "WED", IF(WEEKDAY[Bid Date] = 5, "THU",…
-
Having problems embedding Smartsheet into new Google Sites
Hello, I am not able to add my DevOps course list attendees embed with a Smartsheet into the new Google Sites. I can easily embed other sites like soundcloud (works rather well). Please help - thanks.
-
Losing data when multiple users making changes at the same time
Hello, I am having the exact same issue as Thor did in 2015 - https://community.smartsheet.com/discussion/385/losing-data-2 I sent out a current user view report to my project managers and when they all update their individual rows/reports respectively, I keep losing the data in my cells. How do I ensure to get their…
-
Issue: incorrect numbering of attachment versions
I faced this issue when three and more files are attached to the row. In this case, their numbering becomes incorrect. For example, the latest version of the file can be marked as V2 or V3 whereas it should be V4 (in case if four versions of a file are uploaded). This causes a mess and the only way out I see so far is to…
-
Best way to automate sending a row attachment to an outside client?
For each job my business completes, we record the job and all information in a single row. Once the job is complete a report is generated with Smartsheet merge in Google Docs and saved to the specific row for the job which also includes the client's contact email. Regardless of how the attachment arrives at the sheet row,…
-
Compare the hours allocated to the hours actually worked, through timesheets
Hi, I need to compare the hours allocated to the hours actually worked, through timesheets. For this I am using a spreadsheet to aggregate all the data from timesheets in order to extract metrics of hours worked by time and in which projects. This time worked on projects would be compared to the time allocated to the…
-
I want to add an "OR"statement
-
Auto Assign Contact based on number of Open Tasks
Any help would be great. I have a form that dumps information into my sheet and would like to auto assign the task to a person/contact when it comes in. The Assignment is on a rolling basis. For example I have 4 people and as the work comes in it gets assigned to each one then starts again at the top of the list. Has…
-
adding email adress/people into contact group (issue)
Hello everyone. I often create contact group. I used to be able to put any email adress/people I wanted into these contact groups...until today. I created new group today, and for some reason, I sometimes get a message saying "you cannot add this user to this group". This message seems to happen only for specific people…
-
Nested If/And but need and And/Or
I am trying to have the Opportunity Status ball automatically turn green when the four columns to the right are Green OR Gray. I can get the formula to work with just "Green", but when I try to put the OR "Gray" into the formula, it results in a yellow ball or unparseable. =IF(AND([Commercial Business Case Completed]1 =…
