-
Combine values in column only if value in each row is less than a value
I have a column with an identifier in each row and in another column I have a value in each row. I want to search the second row for any values that are less than a reference cell, and if less that that reference cell, I want the text from the first column to be displayed in the cell the formula is in separated by , if…
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
Why is my Download Files link grayed out?
I am trying to download multiple files from a smartsheet into a zip file but when I go to click download files the link is grayed out and I cannot click on it. Any ideas why that would be? I own the sheet so it shouldnt be permissions based. Thanks!
-
Tracking a sum from separate column of specific values
Hello, First, I want to thank all of you for your help on this community. I'm learning a lot and this place has helped me out immensely. I've looked around and have found some similar questions, but I can't seem to get this to work, so I want to turn it over to y'all. So let me start with a snapshot of my sheet. What I…
-
How to change first week number from Jan 1 to July 3 ?
How to change first week number from Jan 1 to July 3 ?
-
Copy and move row workflow disabled by smartsheet
My copy/move row workflows (that previously worked) were disabled yesterday. I now have an error that says "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet." Anyone else have this issue? If this is new functionality, then the workflow will only work…
-
It there a formula to use so that I can calculate an amount between dates?
Hi! I am trying to calculate the amount outstanding between certain dates, but I can't figure out what to use or if that is even possible.
-
Auto calculate the estimated date of completion
Hello, I want to auto calculate the estimated date of completion based on the current status and pending work items in the backlog.
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
Hard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type of formula or function that would allow us to type an employees name in next to the…
-
Who gave access to view or edit SmartSheet
Hi, i have this basic question. Is there a way that i as admin can see a log of who of the other admins or Editors - Can share gave access to other users to view or edit some smartsheet or workspace? Thanks in advance
