-
Compare Date in [Start Date] to a value in a text/number column
I need to compare the date value that is in the Start Date or End Date to a date value that is in a text/number column. When I compare the two, I get "#Invalid Operation." If I change both columns to Date columns, it works, however that does not work well with my spreadsheet. Are there any tricks to doing this? Thanks
-
Nested IF Statements
Brand new to SmartSheet. Looking for best method for nested IF/THEN statements to provide status. Or alternate methods. Example... IF column N has any value, THEN column B shows Status 1, IF column O has any value, THEN column B shows Status 2, etc. My nested IF/THEN statement from Excel didn't import.
-
Indenting not working right
See screenshot. When I indent my headers, the expand/minimize button is all the way to the right (circled in red). I would like it to be in the cell with the header label. I cannot figure out why it keeps putting it all the way at the end. Second- When I try to do additional indenting below that point, it doesn't seem to…
-
Edit content in Sights.
I just started using sights. I see that it is not possible to edit individual cell directly from sights, or am I mistaken? Is there a way to do this? It would be very helpfull if I could. I would also love to be able to edit the comments field directly from sights as well. Is this possible?
-
Errors in Changes made by
I have automatic reports sent out when an item is past due. Sometimes the person listed at the bottom is not the person who made the change. Any way to prevent this? Glenn
-
Images inserted in the cells disappeared
Hi everyone, I just got a weird problem with images in cells. We were using this feature for a while now, and we had an uploaded .jpg images in every row, while we got to approx. 500 rows. Right now all our images disappeared and were replaced only by images' former name (like image.jpg) text in that cell. When I…
-
Time Between Dates, dependant on status of another column
Hi, Hopefully I can get this to make sense. We have a spreadsheet that has a Date Reported Column and classification column (classifications being - near miss, incident, injury) with a formula column. Is there a way to create a formula in the formula column that has the number of days between today and the latest date in…
-
Using multiple functions in a formula
Hi, I am using a formula to determine "Planned % Complete" based on start date/end date and todays date. The formula I am using is; =(MIN(TODAY(), Finish1) - Start1 + 1) / (Finish1 - Start1 + 1) I want to nest the following formula so that if the start date is AFTER todays date, the "Planned % Complete" will be zero;…
-
Weekly columns
Hi there I think I am missing something here. I want to set up a list of tasks which will be due in certain weeks of the year and are repeated. For example. * Review website pages... Second week of each month * Write a blog article: Last week of the month * Post Facebook update: Each week. Do I set up 52 columns with the…
-
Sheets vs Workspace
New User: Confused do I setup Sheets or Workspaces. 7 companies, coworkers share documents and scheduled tasks. Do we set up both?