-
Unable to add image in file upload feature on form?
We building a form/questionnaire and are trying to insert an image into a form as a form element. To do this we tried to add the "file upload" form element and upload the image as a file in the field settings. However, when we try to click "browse files" or "file upload" in the field settings, it does not allow us to…
-
I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?
I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET. =COLLECT({2024 All Projects}, {2024…
-
Nested IF formula with If/And
Hello, I have the following formula that works, I just can't figure out how to include the date qualifier. Can someone please help? Thank you in advance! If the assigned PCD is one of two people, I need my manager column to read Manager A's name. If it is anyone else, I need it to show Manager B's name. I want to add that…
-
Duplicate row, change Status column to "inactive" based on date feild
I have a list of names and would like to change the status of old rows to 'inactive' when a new submission for that name comes in. So only the most recent submission stays as active Thanks!!
-
Conditional Format For "Task Bar" independent of "Entire Row"
My use case I have rules for various rows based on the Issue Type and I want a rule for the Task bar based on the status of the issue. For example, I want an Epic to show up with a Grey background, but I do not want the grey background to extend into the Gantt Chart but I want the Gant chart to show up as Green if the task…
-
Multiple Criteria
I am working on pulling information using a countifs =COUNTIFS({020-Contracts - In Queue Range 1}, "Agency Wide", {020-Contracts - In Queue Range 3}, "Requested") Here in lies my issue, for the range 3, I want it to only count if its any of these: 1-Requested 2-Assigned 3-In Progress 4-Approvals Requested 5-Obtaining…
-
Drag and Drop in Timeline view
It would be great if I could move the boxes around in Timeline view by dragging and dropping. Currently the only way to move them is to edit the dates in either the box details or the grid itself.
-
Better search highlight for visibility
Guys when you use ctrl F to search in a sheet for a value, the way the search result gets highlighted is a joke. It's like a gray box that can barely be seen, especially if the cell has a similar color. Why can't you make it so that the search result gets a huge yellow box around it or something? I can't even tell you how…
-
"Trace Dependents"
Hello Community, Excel has this "Trace Dependents" function which enables to know if (and where) a cell is refered in another cell formula. I can see that when a cell is further used in a smartsheet formula, the cell has tiny black/blue arrow. But I struggle to know the cell dependance. Any clue ? THanks
-
Timeline view and multi-value fields
Hello All, I really like the Timeline view based on a start & end date but am hitting a wall trying to show a similar but slightly different perspective. I have a list of projects (each one row) and one of the fields is a multi-valued field of team members who are working on that effort. Is there a way to get the project…
