-
Why is a formula not triggering unless someone opens the sheet?
Hi there, I have 150 sheets that individuals use as time sheets. The sheet has rows for all the dates for a quarter. I have a "Current Month?" check box column in the sheet that checks the cell if the row date is in the current month. It uses this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) I have another check box…
-
Merged: Let Smartsheet use row numbers
This discussion has been merged.
-
Multiple cross references for one sheet?
Hi, here's the situation. Sheet A is a master list of employees with their title, supervisor etc. Sheet B has a column that is set up as a dropdown list of names of said employees. When I choose an employee on Sheet B I have it cross reference with Sheet A to pull the supervisor and some other information to fill in…
-
Personalised view on sheet
I think it would be good if we could have customisable (to an extent) on sheets or an option that people are allowed to do so if granted access on a sheet. Some people wanted "highlighted changes" or "frozen columns" on and other do not. Is there a way to add it to your filter maybe so people can opt in to those being on?
-
Edit in Proofing
What would you suggest to a customer who is looking to use the proofing tool to collect comments and request approval but would also want to be able to make changes to the word document without having to leave Smartsheet? At the moment they have to go out of Smartsheet, find the document in Sharepoint and edit the…
-
Merged: Ability to add character limits to Text/Number column type
This discussion has been merged.
-
Duration Column with Formula/Dependencies
Hello, Currently, I use a Text/Number column for task duration. I have a workflow set up to change the duration of each task depending on the urgency (either urgent or non-urgent), which is calculated using several weighted questions in the Sheet Summary that populate either a 0 (non-urgent) or 1 (urgent). This setup…
-
Retrieve the form URL via an API call when the sheet is created
Hello Smartsheet Community, I hope you're all doing well! Im relatively new to smartsheets and I'm currently working on an automation process using the API's within Smartsheet where new sheets are created from a template. This template has an attached form that is crucial for our workflow. Currently, we can retrieve the…
-
Referencing report data in a sheet/formular
Hi all This may be a silly question, but a quick google search seems to say this is impossible; I want to use a report to sum up all tasks overall/done/gone past deadlines, and then use a formular in a sheet to add them all up and be used for a graph. Thing is, it seems I cannot reference a report into a sheet? This feels…
-
Assistance pulling information from one sheet to another automatically
Hello, SmartSheet Community! I could use your help. I have created an example of my problem below. The actual sheets have many more columns. Sheet A needs information sorted by Person Name; Sheet B has information sorted by Pet Type. Sheet A - This is where I would like information to be filled in automatically based on…
